Auto Refresh

Emerus CCC

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.

Andrée Starå

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!

Emerus CCC

What is Zapier?

Andrée Starå

@Emerus CCC

More info.

https://www.smartsheet.com/marketplace/apps/zapier

PPS Solutions

HI @Emerus CCC , we have developed an auto-refresh app, feel free to contact us for more details,

Cheers

Peter

tedmichon

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.

1. Added a column called Today, hid it
2. 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.