Add 'Refresh Sheet' to work flow

I have a sheet which is full of formulas pulling data from a number of different sheets in order to graph the data onto a dashboard. I have noticed some issues when looking at the graph on the dashboard recently and have just figured out it is because the sheet requires updating.

A few of my formulae reference TODAY(), to establish whether tasks are due today or overdue so ideally I would like to update this sheet everyday.

Under Automation>Workflows>, it would be handy if there were an update/refresh sheet option.

Sign in to vote!

Find more posts tagged with

Automations

Idea Submitted

Workflows in Smartsheet

Comments

Samuel Mueller

@jamie.harbottle please see this communication to help assist with this issue NEW Help Article! Automatically update the TODAY function in formulas — Smartsheet Community

jamie.harbottle

https://community.smartsheet.com/discussion/comment/408458#Comment_408458

Thanks, I had previously seen this post and tried to implement. Unfortunately it did seem to work however I have now implemented this to all sheets referenced and am hoping this will work.

It's a shame that it isn't a built in workflow action though.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.