Automations Between Sheets Without Formulas

muellerk

I'd love to be able to change cell values in a sheet or copy/move a row of one sheet based on the value in another sheet. You can technically set up a formula to change the cell value using some kind of lookup but I'd like it to be a one time thing and then have the user edit the cell manually after.

The example I have is a project's health and status. Based on our intake sheet when the project is approved I'd love the the status of the project to automatically change to Ready to start but then have the project manager change the status's after that initial one as appropriate for the project.