Forum Discussion
- MarkShnier__YouQrew 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])
- KathyBenjaminQrew Trainee
Thank you, worked perfectly!