Formula that does i=i++


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!