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

guy.rooker83086

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.

JeremiahHorstick

The IF function will work fine for this.  

Andrée Starå

Hi Guy,

I agree with Jeremiah.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, [email protected])

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

guy.rooker83086

Thanks I didn't even think about doing it with an in cell formula.  The nested If statement worked.