Formula results varying between today and yesterday

David Johnson
David Johnson ✭✭
edited 12/09/19 in Formulas and Functions

I have a formula pulling info from another sheet.  This then feeds into a dashboard metric.

The formula is a COUNTIF for anything with today's date.  What is happening (and this sounds crazy....I had to get a couple of people to observe it to confirm it wasn't just me) is that at some moments in time the figure on the dashboard is working correctly, and then at other times it will show the COUNTIF result for yesterday.

The figure will change during auto refresh of the dashboard and I can't for the life of me figure out why.

I've attached a screenshot of the formula in the sheet.

Help please!





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!