Trying to Count how many times a specific date populates

Rachel Rudd

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.

Bassam Khalil

@Rachel Rudd 

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 Khalil

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.

Rachel Rudd

https://community.smartsheet.com/discussion/comment/297101#Comment_297101

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

Bassam Khalil

@Rachel Rudd 

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))

Rachel Rudd

Aha, that finally worked. Thank you!

Bassam Khalil

@Rachel Rudd 

Excellent, Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"