How do I update multiple cells when one cell is updated?

Kenya Asbill

How do I update multiple cells when one cell is updated?

Example A: If Done is checked, then Status is updated to Completed and Progress is updated to Full.

Example B: If Status is updated to Completed, then Done is checked and Progress is updated to Full.

Paul Newcome

You can automate two off of one, but you won't be able to fully automate all three. Once you manually change the data in a cell, it will remove the formula.

Paul Newcome

You can automate two off of one, but you won't be able to fully automate all three. Once you manually change the data in a cell, it will remove the formula.

Kenya Asbill

Thank you!

Paul Newcome

Happy to help. 👍️