Counting Check boxes when Checked

cjleon

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!

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, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting