Trying to Count how many times a specific date populates
I am trying to count how many times each of of the dates in 'Clean Up Date' populate so I can set up a notification to deactivate the form that feeds into this sheet after 8 people sign up for each date. I've tried typing in CountIF formulas referencing similar questions asked in the past but nothing is working. I even tried to see if I could count the colors and that doesn't seem to be an option either.
The 'Count' column is a helper column I'd like to put the formulas into to count off to the side.
Best Answer
-
please check the following for your "Clean Up Date" column type:
if you select Date type for this column then the user will select the Date in correct format from the form, after that you can use the following formula to count for example for ( 12-Aug-2021 )
=COUNTIFS([Clean Up Date]:[Clean Up Date], DATE(2021, 8, 12))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Rachel Rudd
Hope you are fine, the date column you are using isn't a Date type column because smartsheet doesn't use this format for dates. please check.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Should I switch them to 7/15th and try to find the formula to count it that way? The dates are 'Default Values' from a form each person will fill out to sign up for each date so I can make sure it populates just the same date
-
please check the following for your "Clean Up Date" column type:
if you select Date type for this column then the user will select the Date in correct format from the form, after that you can use the following formula to count for example for ( 12-Aug-2021 )
=COUNTIFS([Clean Up Date]:[Clean Up Date], DATE(2021, 8, 12))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Aha, that finally worked. Thank you!
-
Excellent, Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
Check out the Formula Handbook template!
