Trying to Count how many times a specific date populates

07/06/21
Accepted

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

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    edited 07/06/21 Accepted Answer

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

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ 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

  • Bassam KhalilBassam 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.

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ 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

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    edited 07/06/21 Accepted Answer

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

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ 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!

  • Bassam KhalilBassam 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"

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ 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"

Sign In or Register to comment.