I need your help. Working with an IF and a ISPICKVAL formula that has messed with my mind! Essentially I need the formula to do:
If my picklist value = X, then I need the appointment value field to = Y.
I thought that should be easy! The following formula works great:
IF(ISPICKVAL(GroupEventType,"Appointment F2F new" ), 2,0)
However I have 14 picklist values with varying appointment values, i.e Appointment F2F exisiting worth 1 and Full day exhibition worth 3 and so on. As soon as I add another line to this formula I get syntax errors, I feel like I have tried 101 slightly different versions but am drawing a blank. Any help would be greatly appreciated.
Have a lovely evening all and let me know if you need to ask any further questions.
Thanks
Tracy
11 answers
Okay try using
CASE(TEXT(GroupEventType),
"Appointment F2F New",2,
"Appointment F2F Existing",1,
0)
and use the Value API Names instead of the Picklist Values
