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
The Quick Base IF will evaluate the logic in sequence and stop at the first true statement. Note that to test a text field as being blank, you may not compare to Null. You need to do it like I have below
If(
[Submitter's Status]="Started"and [Confined Space]="Yes" and Trim([Safety Manager Status]" = "", "Safety Manager to Review",
[Submitter's Status]="Started"and [Confined Space]="Yes" and [Safety Manager Status]="Approved", "PTP Approved",
[Submitter's Status]="Started"and [Excavation]="Yes" and Trim([Safety Manager Status]" = "", "Safety Manager to Review",
etc
If(
[Submitter's Status]="Started"and [Confined Space]="Yes" and Trim([Safety Manager Status]" = "", "Safety Manager to Review",
[Submitter's Status]="Started"and [Confined Space]="Yes" and [Safety Manager Status]="Approved", "PTP Approved",
[Submitter's Status]="Started"and [Excavation]="Yes" and Trim([Safety Manager Status]" = "", "Safety Manager to Review",
etc