Changing a cell value, in a drop down column


Hi everyone, can anyone help?

I am trying to change the Status of an activity from the Check box Step completion. I have Sales Step 1-6 in a drop down column, and I have Columns 1-6 as checkboxes. I want to check Step 1 to move the cell value to Step 2, Check step 2 to move the cell value to Step 3 etc.... I am struggling and this is as far as I have gotten:

=IF([Step 1]@row = 0, "Step 1", "Step 2", IF(AND([Step 1]@row = 1, [Step 2]@row = 1), "Step 3"))....

Any ideas guys? Help appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!