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!
