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

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.


Answers

  • Jaime Ciabattoni
    Jaime Ciabattoni ✭✭✭✭

    @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

  • 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å
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • 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å
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • @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
    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å
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!