Method to update field automatically (based on other field updates)

edited 12/09/19 in Formulas and Functions

I was looking to see if there was a way to make an update to a field based on the status of other fields in the sheet.  In my example I have a review process that sends multiple emails at once for review and approval.  The reviewers each have a field that the indicate approved or rejected in.  Once all of them have approved I want to update the overall request status.  If any of them reject it then that triggers a different status update.

I can get it to send me a "Request an update" function for me to update the status field but I would rather not have to manual update the status.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!