Hi,
I have three tables with reference lists. With your help I was able to pull lookuprecords with contain formula. However, now I want to check if the any of the lookuprecords has a specific value.
I have created a public doc; here is the link http://139.180.223.0:8484/o/docs/vpnkxDdUdUFs/Untitled-document
In the status column of the Campaign Requisiton Form table, I want to check if any of the returning data is “Campaign Running”. If any of the data contains Campaign Running, I want the status to retunr “Active”, if not then “Finished”.
Thanks for your help!