Counting Check boxes when Checked

02/26/19 Edited 12/09/19

Hello,

 

I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. 

Another solution I'm thinking is possible is if there's a way to auto-fill another column when done is checked with "1" and then extract the date of that into another column.

 

Thanks!

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    To count the checked boxes is easy but to know the date you'd either have to check each cell/activity log or use a third-party service like Zapier to set the date it was checked.

    Would that work?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, [email protected])

    Hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thanks for the quick response! I was thinking it seemed more of a manual process.

     

    So, in the image below it shows each status we have. The Done status isn't included because it counts the how many Closed projects there are.

    *A Closed project can include Rejected and Complete*

    That is why tracking when done is checked is important!  Let me know if you have any other questions about it!

    request by type.JPG

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    I've completely missed your post. Did you get it working?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.