If Box is checked change priority to blue

Jhoaas

How can i setup this scenario: I have one column with Priority and one column with checkboxes. I would like it to change the priority to blue (from red, yellow, green) if i check the box. I cant do this with conditional formatting, but maybe a formula can?

Paul Newcome

Are you wanting to also change it to the other colors through the formula, or do you need it to be manual selection?

Jhoaas

No, just to blue. I manually set the priorities as needed, and when i complete the item i check the box. That is when i just want it to "reset" the priority to blue.

Paul Newcome

In that case you would need to set up a Change Cell automation triggered when the box is checked. It may take a few minutes to kick in and whatnot, but it will be done automatically.

Jhoaas

Shoot, i should of thought of that! I do that already for adding a completion date when its checked too.

Paul Newcome

Happy to help. 👍️