Disable auto refresh?

edited 12/09/19 in Formulas and Functions

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?


  • L_123
    L_123 ✭✭✭✭✭✭

    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?

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    The options for auto-refresh on a dashboard are (in minutes)










    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!