Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
4 months ago

Formula help for Multi Select Text

Hi, I'm looking for help with a formula to display a field that is a Multi Select Test field and if blank display another Multi Select Text field. Example: If [LG Audit] is blank display [Out of Sc...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 months ago

Try this.  I'm assuming that if [LG Audit] is not blank then you want to display [LG Audit]

IF(Trim(ToText([LG Audit])) = "", [Out of Scope], [LG Audit])

 

 

  • KathyBenjamin's avatar
    KathyBenjamin
    Qrew Trainee
    4 months ago

    Thank you, worked perfectly!