If checkbox is checked select this option from dropdown list

Ben Price

Does anyone know how to write this formula correctly? 

Basically, I've got a "completed" column that is a check box column. 
I've got a "priority" dropdown column with several different levels of priority includeing "none" so that I can sort my reports via priority. 

 

I would like the priority column to go "none" when I check the completed button from a row. 

 

Sorry, I'm a little new to formulas and just need a little help getting off the ground here. 

 

Thanks!

 

-Ben

J. Craig Williams

Ben,

 

The problem you will run into is that you likely want the Priority column to be both manually updated and automatically updated. In effect, manuallly until it does not matter anymore. Smartsheet (or other apps with formlulas that I am aware of) don't do that. You would need some scripting or macro language to override the manual entry.

Smartsheet does not have that (yet?).  There are third party tools that can do this for you, but this is overkill for this simple problem.

 

What I do is have the columm with the drop-down be a separate column. Call it "user defined priority" - but there are more elegant names. The "actual priority" then resides in a separate column with a formula

 

=IF([Completed]23,"None",[user defined priority]23)

 

for row 23, with column names in [].

 

Hope that is clear and helps.

 

Craig