Formulas not updating when new data is added to underlying sheet
When new data is added or updated to the underlying sheet, the formulas are not recalculating. I run an upload workflow each morning and want the metrics sheet below to recalculate based on the updated report I attach. I have to manually re-enter the formula to get an updated metric. The counts, averages and formulas using 'Today' all have to be manually recalculated.
How do I ensure formulas will update as the underlying sheet does?
Help Article Resources
Check out the Formula Handbook template!