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
Ryan, sorry try this
If(
[Submitter's Status] = "Started"
and [Confined Space]="Yes"
and Trim([Safety Manager Status]) = "", "Safety Manager to Review")
If(
[Submitter's Status] = "Started"
and [Confined Space]="Yes"
and Trim([Safety Manager Status]) = "", "Safety Manager to Review")