Question

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

Genevieve P. · Accepted Answer

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

NCH · Accepted Answer

Thank you. I will look into this.