Counting Check boxes when Checked

edited 12/09/19 in Formulas and Functions



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.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!