New answers tagged

0

Is this what you are looking for? =OR( LEFT([Ticket Number],6)="TASK00", LEFT([Ticket Number],6)="RITM00", LEN([Ticket Number])=0 )


1

Try using below formula: =IF([ChoiceField]="New York","Person1",IF([ChoiceField]="Florida","Person2",[ChoiceField])) This formula is similar to: if(ChoiceField === "New York") { CalculatedValue = "Person1"; } else if(ChoiceField === "Florida") { CalculatedValue = "Person2"; } else { CalculatedValue = ChoiceField; } IF Function: Returns ...


Top 50 recent answers are included