If Box is checked change priority to blue
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?
Answers
-
Are you wanting to also change it to the other colors through the formula, or do you need it to be manual selection?
-
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.
-
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.
-
Shoot, i should of thought of that! I do that already for adding a completion date when its checked too.
