Is there a way to jump to a specific cell automatically in a Smartsheet

Options

I created a calendar for our staff to let the receptionist know where they are everyday so she knows how to handle their phone calls. I am wondering if there is a way that when that specific Smartsheet is opened that it will automatically jump to the specific date relative to the actual date showing on the computer?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Shauna Brotz

    What I would do in this instance is set up a helper column in the sheet with a formula to check the Date against Today's date. If it's Today's date or in the future, check a box.

    =IF([Date Column]@row >= TODAY(), 1, 0)

    You could also make the date range 1 week:

    =IF(AND([Date Column]@row >= TODAY(), [Date Column]@row <= TODAY(7)), 1, 0)


    Then you can set up a Filter on your sheet to filter by this helper column to see if it's checked or not, displaying only the rows you want to see. You can set this filter up to be the default on the sheet when it's opened. See: Set a default sharing view

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!