+ Start a Discussion

formula help for number field

Hi All,

I want a formula for the below scenario.

If the value of field 'A' is 'One' , then i want the value of field 'B' (number field) 'B+1'.

It may be simple but mind is not working today..

Amit Chaudhary 8Amit Chaudhary 8

please try like below

CASE( Field_Name__C
"One",B =B+1,

Let us know if this will help you
Karthi XaviKarthi Xavi
You want to do it with a Field update or with a Formula field?
Hi Karthikeyan,
Thanks for looking into this
I want to with a formula field if it fits my scenario.