Maybe a little long, but some backstory is necessary to get a better understanding on what's going on and if I'm approaching this issue right.
Currently my Smartsheet is setup where there is a formula in the "Status" column that checks if there are less then 2 names in the "Total Emails per Application" Column.
The "Total Emails per Application" column gets its number from the User Emails + Emails to Add - Emails to Remove columns.
In the screenshot above, say there are two users in the "User Emails" and "Total Emails per Application" field. If a user would type in one name in the "Emails to Remove" field and change the status to "certified" then that means there is now one name in the "Total Emails per Application" field.
We don't want that because we don't want a user to be able to have one person assigned to the "Total Emails per Application" column, still be able to change the status to "certified" and click save.
I don't believe there is a way in Smartsheet to prevent a user from saving in these types of situations. For what its worth the person that requested this project wanted a way to prevent users from having the option to select "certified" unless that "Total Emails per Application" number was two or higher.
As a work around I put a formula in the Status column that reads:
=IF([Total Emails per Application]@row < 2, "Additional Research Needed", "")
However, that formula for some reason is preventing me a person who has admin rights to the smartsheet unable to modify the Status column. Notice in the status column above, its blank and I can't change the values in that field at all until I remove the formula.
Also, the formula above, I originally had it as
=IF([Total Emails per Application]@row < 2, "Additional Research Needed", "Certified")
That was great, but the problem was that it auto changed the status column to "Certified" or "Additional Research Needed" thus preventing users the option to select the status.
Hope all this makes sense.
So question is am I approaching the issue the right way or is there a better to write the formula I have in the status column?