Sheet Summary COUNTIFS Formula Not Adding Correctly

NCH

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.

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

Thank you. I will look into this.

NCH

Today it is off by one instead of two. Any help would be greatly appreciated.

Genevieve P.

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

Thank you. I will look into this.

NCH

Thank you. This seems to have worked.