Automatic Status Update

Mike Rini

I've setup a formula which tells me if an entry that was submitted was correct / incorrect. I've also triggered an email based on that to send an email requesting an update to the specific field in question. What I can't figure out is if/how I can switch the status of that row.

In my sheet we have several statuses (Not Reviewed, Pending, Rejected, etc.). In this case, when both things happen, I want to set the Status field to Rejected - is there any way?

Andrée Starå

Hi Mike,

If you want it to be automatic, then you won’t be able to change it manually, or you’d need to use something like a third-party service like Zapier to automate it. Is that an option?

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!