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

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

  • 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

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!