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.

MarkShnierYou · Answer

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

Sign up

Login to the community