function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Cat StolzCat Stolz 

Check if value included in list

I have a list of values (cities) for a report, and I need to check if the current value in MailingCity is on that list and return a message if it is not. I'm not sure how to approach this in a formula field. Thoughts?
Suraj Tripathi 47Suraj Tripathi 47
Hi Cat,

you can do this task using apex trigger because you have to check data from the list so using trigger approch is more 
suitable for this problem.

If you find your Solution then mark this as the best answer.

Thank you!
Regards,
Suraj Tripathi