Reports Not Updating Live
I'm trying to shift our company towards using reports more, instead of multiple people interacting with sheets directly (and thus making version control difficult when minor items are changed, particularly on Control Center provisions) -- To this end, I've been given feedback about reports that indicate that they do not update formulas, automation actions, or conditional formatting live. This means that whenever a user needs data on the sheet updated to match what they've entered (this could be as simple as a sum of the cells they're entering into on a header, or as complicated as an index/match formula checking to make sure a vendor they enter is in our database), they're required to save the page, then completely refresh the report. This makes what would otherwise be a preferable avenue for handling data a slog of extra actions that the user must take.
Is there any way around the constant save/refresh loop when interacting with data via Reports?