Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
6 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 Scope].  Is this possible?

Thank you in advance.

  • 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])