Help

If lookup contains anything other than

814 1
cancel
Showing results for 
Search instead for 
Did you mean: 
hayley_coneill
5 - Automation Enthusiast
5 - Automation Enthusiast

Can’t seem to find a solution. I have a lookup that pulls the status of an asset in a linked field. If there is more than one asset in the linked field i get multiple statuses in the lookup. I want a formula that states “ :white_check_mark: Done!” if the lookup has only “Final Approved” statuses. How can I write a formula that says "contains only “final approved”? When the lookup has statuses other than “final approved” I want the formula to say “work in progress”. So i’d need a command that says "contains anything other than “Final approved”.

1 Reply 1
hayley_coneill
5 - Automation Enthusiast
5 - Automation Enthusiast

Of course right after I post I find a solution…Find() worked just right.