I have a sheet with multiple countif formula referencing data from multiple sheets.
From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it.
However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go into the sheet I see the totals there have reverted back to a previous (and incorrect) set of totals. Within 5 seconds it switches to the correct totals.
Currently, the only way to ensure people have the correct data is to log into the sheet regularly which is not feasible.