Formula help for Multi Select Text

Question

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.

markshnier__you · Answer

Try this.&nbsp; 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])&nbsp;&nbsp;

kathybenjamin · Answer

Thank you, worked perfectly!

Forum Discussion

Formula help for Multi Select Text

2 Replies