Sheet Summary COUNTIFS Formula Not Adding Correctly
Hello, I have a formula that counts how many times a call reason for "Application Assistance" is selected today. The formula worked fine the last two days but is adding two more to the total for today on the sheet than what is there when I filter. Can you please assist?
=COUNTIFS([Call Reason]:[Call Reason], "Application Assistance", [Contact Method]:[Contact Method], "Inbound Call", [Created Date]:[Created Date], TODAY())
Best Answers
-
Hi @NCH
Is your "Created Date" a system column? If so, you may be running into a discrepancy between the display text of the System Column and the timezone that the actual data is coming from.
System Date columns are stored in UTC+0, so depending on where you're located, is it possible that there is a row or two that is displayed in your timezone as yesterday, but in UTC it would be considered Today?
If this explains your issue, I would suggest using a Record a Date workflow to set the date that the row was created instead of using the System column. (See: Set the current date with the Record a Date action)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you. I will look into this.
Answers
-
Today it is off by one instead of two. Any help would be greatly appreciated.
-
Hi @NCH
Is your "Created Date" a system column? If so, you may be running into a discrepancy between the display text of the System Column and the timezone that the actual data is coming from.
System Date columns are stored in UTC+0, so depending on where you're located, is it possible that there is a row or two that is displayed in your timezone as yesterday, but in UTC it would be considered Today?
If this explains your issue, I would suggest using a Record a Date workflow to set the date that the row was created instead of using the System column. (See: Set the current date with the Record a Date action)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you. I will look into this.
-
Thank you. This seems to have worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!