Forum Discussion

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

Qrew Legend

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

Qrew Trainee

4 months ago

Thank you, worked perfectly!