Counting Check boxes when Checked

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!

Find more posts tagged with

Forms

Manufacturing

Formulas

Services

Support

Community Platform

IT & Operations

Project Management

Comments

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

cjleon

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å

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

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.