If Box is checked change priority to blue

Jhoaas
Jhoaas ✭✭
edited 06/13/23 in Smartsheet Basics

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