Countif todays date and by someone

12/14/20
Accepted

I want to count how many times someone completes a form today

I was able to count if yesterdays date with:

=COUNTIFS({Store}, $Name6, {Created}, TODAY() - 1)

but can't find a way to calculate todays entries

Best Answers

  • Mark CronkMark Cronk ✭✭✭✭✭
    Accepted Answer

    Hi @Kate Arrold ,

    =COUNTIFS({Store}, $Name6, {Created}, TODAY()) should do it.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Mark CronkMark Cronk ✭✭✭✭✭
    edited 12/15/20 Accepted Answer

    Try creating a helper date column [Date Created] and input the column formula =DATEONLY([created]@row)

    I assume you're using a system column Created. If not change the formula accordingly. The Created column includes a time stamp. The DATEONLY function removes the time and retains just the date. Use the helper [Date Created] column for your COUNTIFS range.

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark CronkMark Cronk ✭✭✭✭✭
    Accepted Answer

    Hi @Kate Arrold ,

    =COUNTIFS({Store}, $Name6, {Created}, TODAY()) should do it.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Hi @Mark Cronk


    I thought it was correct but my formula is still showing 0


    I think it might not be refreshing and pulling the data through properly

  • Mark CronkMark Cronk ✭✭✭✭✭
    edited 12/15/20 Accepted Answer

    Try creating a helper date column [Date Created] and input the column formula =DATEONLY([created]@row)

    I assume you're using a system column Created. If not change the formula accordingly. The Created column includes a time stamp. The DATEONLY function removes the time and retains just the date. Use the helper [Date Created] column for your COUNTIFS range.

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Hi @Mark Cronk

    I am trying the above out now but would there be a reason when I use this function that it has a slightly different date



  • Mark CronkMark Cronk ✭✭✭✭✭
    edited 12/15/20

    Interesting. I haven't encountered that. Time zone issue? Just a guess. DATEONLY() should just remove the time.

    Here's an article with a solution. Known issue:

    https://community.smartsheet.com/discussion/70719/why-is-dateonly-returning-the-wrong-date

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • @Mark Cronk allow me to tag onto this discussion. How could I capture "earlier than TODAY?

    =COUNTIFS({DAX Ambient Inventory Actual Install Date}, ISDATE(@cell), {DAX Ambient Inventory Actual Install Date}, TODAY())

    Where and how would I enter <?

    Thanks so much for your assistance. Best regards, Barbara

  • Mark CronkMark Cronk ✭✭✭✭✭

    Hi @Barbara Witt ,

    =COUNTIFS({DAX Ambient Inventory Actual Install Date}, ISDATE(@cell), {DAX Ambient Inventory Actual Install Date}, <TODAY()) should do it.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Sign In or Register to comment.