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.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives