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!
Help Article Resources
Check out the Formula Handbook template!