How to create an auto incrementing number based upon checkbox

matt.lemsing

Hi everyone,

I have a smartsheet where each row represents an "installation". One of the columns is called "Gone Live" and is of a type checkbox. I have created another column entitled "Number of Installs this year".

In this column, I want to create a formula that checks the "Gone Live" field, and if the checkbox is ticked, then automatically increment a number, representing the number of installs so far.

Any suggestions for how I achieve this would be greatly appreciated.

Thanks,

Matt

Andrée Starå

Hi Matt,

Try this formula. It will count all the installations marked as Gone Live.

=COUNTIF([Gone Live]:[Gone Live]; 1)

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

matt.lemsing

Thanks so much.

Andrée Starå

Happy to help!