I want to have a cell incrementally increase by 1 each time a checkbox is selected in another cell

Aswin Ravichandran

There are two columns named

Column4(Column type - text/number)

CHOOSE(Column type - Checkbox)

Whenever Checkbox for reason A is checked I want Column4 to increase by 1. (Ex: If checkbox "A" is checked 3 times I want Column 4 adjacent to it show "3")

Likewise for all 8 reasons.

Smartsheet.PNG

Jaime Elizabeth

@Aswin Ravichandran

From what I can see in the screenshots, Reason A can only be checked once.

With that in mind, it seems like you may be pulling information from more than 1 sheet, is that accurate? We may need a bit more context to be able to help with your question.

Have you thought about having a column that says "Reasons" with the checkbox capability? Then for each entry a person can select any and all reasons?

Then you would need a separate sheet that counts the reasons using a COUNTIF or COUNTIFS formula.

~Jaime

Aswin Ravichandran

Hi Jaime,

Thanks for taking the time to reply. Yes, What I am trying to achieve is- whenever the "reason" is checked and unchecked I wanted the adjacent column to increase by one

I am working on data only in this sheet (Just the 8 Reasons).

I am not opposed to having a column that says "Reasons" with checkbox capability. But, how could a column be used as text and checkbox?

Could you explain more on the idea of using a separate sheet that counts the number of times the reason is selected.

Andrée Starå

Hi @Aswin Ravichandran

I hope you're well and safe!

You can do this in two ways that I can think of now.

• Workflow with different paths combined with the change cell action would increase the number by one each time the checkbox is checked.
• Workflow that copies the row to another so-called helper sheet and then uses cross-sheet formulas to show the count from that sheet

Would any of those methods work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Aswin Ravichandran

Hi @Andrée Starå

Thanks for taking the time to reply.

Could you please guide me on how to achieve - Workflow with different paths combined with the change cell action would increase the number by one each time the checkbox is checked.

Thanks!

Andrée Starå

@Aswin Ravichandran

Happy to help!

Try something like this.

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

Aswin Ravichandran

@Andrée Starå

Thanks for sharing the image.

I made the changes as above, but I am not getting the count to increase when I check and uncheck the checkbox.

I am able to see the count increase only when I manually trigger the workflow by - "Run workflow now"

Could you please check on that.

Thanks!

Paul Newcome

@Aswin Ravichandran I would suggest setting up a second sheet with the same columns. You could then set up a copy row workflow that will copy the row whenever the box is checked.

Then to get the total count of how many times that particular letter was checked you would use a cross sheet COUNTIFS like so:

=COUNTIFS({Second Sheet Reasons Column}, @cell = REASONS@row)

Andrée Starå

@Aswin Ravichandran

You're more than welcome!

Try changing the trigger section so it triggers when it changes to checked and unchecked too.

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!