Have an IF Statement Change the status of a field when a value in another column is less then 2
Title is worded weird, but here's a better explanation.
I am looking for an IF Statement that reads "If Total Emails per app is less than 2, then change status to Additional Research Needed."
Here's my attempt at the formula:
=IF([Total Emails per Application]:[Total Emails per Application] < 2, "Additional Research Needed", "Certified")
In the screenshot below, I am getting an "Invalid operation" error.
But basically what I am trying to do is to prevent users from selecting "certified" if the total emails per application is 1 or 0.
Help Article Resources
Check out the Formula Handbook template!