Auto Refresh
Is there a way to set sheets to auto refresh? I have several reports set up for sheets, but will not refresh unless done manually.
Also, when sheet B is updated from data entry from sheet A, conditional formatting does not update on sheet B until manually refreshed.
Answers
-
Hi @Emerus CCC
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, the third-party service, Zapier, is an excellent option for this scenario.
Is that an option for you?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
What is Zapier?
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
HI @Emerus CCC , we have developed an auto-refresh app, feel free to contact us for more details,
Cheers
Peter
-
I have answer that worked for me. I have a sheet that sends out expiry notices 28 days before a certificate expires. But for it to work, I need to refresh the sheet daily so it has the correct number of days until expiry.
- Added a column called Today, hid it
- Created a workflow to run 1 hour before the expiry check runs, and does the "Record a Date" action in the Today column.
This effectively refreshes the sheet (recalcs the number of days until expiry), so when the Expiry check runs, it is looking at a newly refreshed number of days.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives