Sign in to join the conversation:
I want to make a dashboard that pulls data from another sheet, but I only want to update it once a week. Is there any way to delay the auto refresh?
I depends on how the sheet functions. If the sheet is web form based, then it is a relatively straightforward matter to do this. If you are editing values and modifying rows, it becomes much more complicated. What does your sheet do and how is it modified?
The options for auto-refresh on a dashboard are (in minutes)
1
2
3
5
10
30
60
.
Unfortunately there are no other options. This includes not having the option to even just turn off the auto-refresh and manually do it once a week. It is a good idea though. Feel free to Submit a Product enhancement Request.
In the mean time... Can you explain your process in more detail? There may be a way to structure the data itself so that it only pulls one week at a time.
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
How can I change the value in one row based off of information in that row and information in a predicessor row
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
