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

  • Genevieve P.
    Genevieve P. Employee Admin
    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
    NCH ✭✭
    Answer ✓

    Thank you. I will look into this.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!