Problems report filter and logic formula not recognizing today and yesterday in date column
I'm trying to get my report to filter based on rows where the date column "Last Response Received" is not today or yesterday:
Last Response Received is a date column that has another formula: MAX(COLLECT(External sheet reference)...) which returns the most recent date (from a user's input of form data into a separate sheet) that is sourced from the system created on column.
The problem is that the report is showing rows that have yesterday's and today's dates in it, in addition to the rows that actually meet the criteria.
I can replicate the same incorrect results in a helper column that has =IF(OR([Last Response Received]@row<>TODAY(),[Last Response Received]@row<>TODAY(-1)),"LATE","NOT LATE")
Using the above formula, it returns "LATE" for rows where Last Response Received is yesterday's date.
What am I doing wrong? Is this somehow related to the recurring issue that Smartsheet has with dates and timezones? (Can they hurry up and fix this please?)
Thanks in advance for your help!
Help Article Resources
Check out the Formula Handbook template!