You need to sign in to do that
Don't have an account?
Adam Samuel
Issues using the IF function when creating a formula field
Hi there,
Sorry if this is obvious and maybe I've been sitting oin front of the computer too long, but I'm having trouble writing a string of "IF" statements.
I'm trying to say...
IF field => 1 and <=4 then write "New", otherwise write "Nil" &
IF field => 5 and <=9 then write "Newer", otherwise write "Nil" &
IF field => 10 and <=14 then write "Newest", otherwise write "Nil" &
so on...
Can someone help me please?
Kind regards,
Adam
Sorry if this is obvious and maybe I've been sitting oin front of the computer too long, but I'm having trouble writing a string of "IF" statements.
I'm trying to say...
IF field => 1 and <=4 then write "New", otherwise write "Nil" &
IF field => 5 and <=9 then write "Newer", otherwise write "Nil" &
IF field => 10 and <=14 then write "Newest", otherwise write "Nil" &
so on...
Can someone help me please?
Kind regards,
Adam
Vivek D
I would suggest you use process builder in this case to update a field. Becuase as your condition says so on.. it can reach to 5000 character limit.