How to trigger a sheet to execute its math formulas without opening the sheet
We use a Master Project sheet to track our project status'. The Master sheet pulls multiple data points per sheet from up to 50 sheets. The problem comes in that the math formulas within unopened sheets will not execute unless the sheet is opened. Having more than 50 sheets is a real problem to open each one every morning so the data gets updated at least once a day. Is there any method to trigger all the sheets to update without having to open each one?
Answers
-
Sheets can be activated by opening them directly, receiving an update request, receiving a form submission, or having an automation change or add something.
Generally I will set up a hidden date type column and then set up a Record A Date automation to run every day entering the date in the hidden date type column. This will activate the sheet without requiring that it be opened.
-
We will give it a try.
-
Paul, thank you. Your suggestion works great.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives