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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives