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

Shauna Brotz

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?

Genevieve P.

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