Report not updating formula unless the underlying sheet is opened and "refreshed"?
I have a report that brings in a bunch of sheets with one of those "this task was due 15 days ago" or "this task is due in two days" types of formulas. So this report has a due date and this text narrative.
I run the report, and the text is wrong. Like Due Date will show a date in the past, and the narrative will say that the item is due in two days. So I open the underlying sheet, and close it, and the report updates.
Is there something I need to do to make these formulas update?
Help Article Resources
Check out the Formula Handbook template!