Sheet Summary Not Updating Automatically
I have a formula in my sheet summary that uses countif and today (). However the data doesn't automatically update unless I open the sheet and click on the sheet summary. Then I can see the data change in the sheet summary fields. Why do I have to go into the sheet and sheet summary for updates to take place? Why doesn't it automatically update?
Answers
-
Hi @Shelly Toy
This has to do with the TODAY() function - there are certain actions that allow the function to recognize what the date is. Opening the sheet is one of those actions!
The "Usage Notes" section in the Help Article for TODAY() has more details:
If you don't want to open the sheet, there are other ways to create that "refresh". Here's another Community thread that outlines one of these solutions:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives