Formula that does i=i++

Oscar Velandia

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

Andrée Starå

@Oscar Velandia

Happy to help!

Yes, it might be some work initially, but you can hopefully use it for multiple processes.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Ramzi K

Hi @Oscar Velandia,

Are you trying to keep a history of how many times something was selected? If so, the only way to do it is with cell history. Right click on the cell and view cell history.

I hope this helps.

Cheers,

Ramzi

Oscar Velandia

hi @Ramzi

Yes, but I need the number, for me it is useless to see the cell history if I cannot have how many times as cell has taken a particular value

Andrée Starå

Hi @Oscar Velandia

Have a look at my post here.

You could maybe use that method to get the information you need.

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Oscar Velandia

Hi @Andrée Starå

I understand what you meant and thanks a lot, but it is quite a big work @Andrée Starå around just for a counter... I'm gonna explore your idea because it might be helpful for some other things I have

Thanks

Andrée Starå

@Oscar Velandia

Happy to help!

Yes, it might be some work initially, but you can hopefully use it for multiple processes.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!