Forum Discussion

RyanWhitener's avatar
RyanWhitener
Qrew Cadet
6 years ago

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) ...
Formulas and functions
Tables and fields
RyanWhitener's avatar
RyanWhitener
Qrew Cadet
6 years ago
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 )


  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    6 years ago
    Hi Ryan,

    It looks like you just need to change the " that comes after  [Safety Manager Status] to a ) to close out the function.

    Trim([Safety Manager Status])=""

    That was probably just a typo.