Method to update field automatically (based on other field updates)
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
Check out the Formula Handbook template!