Countif todays date and by someone
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
-
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
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
-
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
-
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
-
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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!