If formula for multiple text choice fields
I am struggling setting up a "status" formula. All fields are Multi choice text fields, here is the breakdown: Fields (Possible status) 1. [Submitter's Status] (Started, Submitted, Re-Submitted) ...
Forum Discussion
So just copying and pasting in the first string, I am coming up with the follow error based on the BOLD text
If(
[Submitter's Status]="Started"and [Confined Space]="Yes" and Trim([Safety Manager Status]"="", "Safety Manager to Review")
Expecting )
If(
[Submitter's Status]="Started"and [Confined Space]="Yes" and Trim([Safety Manager Status]"="", "Safety Manager to Review")
Expecting )