Formula that does i=i++

Hi

For those that are familiar with programming, I would like to know how to create a formula that does i=i++, in other words

I have a column with a drop down list ( State 1, State 2 and State 3) In another column I want to count how many times the State 2 is selected, when people go back and forth through the 3 states several times


Thanks a lot

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!