Hey everyone, does anyone know if there is a way to automate the go live date in Smartsheet's?

Ayesha Sharif

To be more specific, I am trying to adjust go live dates in our project plan, but I want to ensure that no matter how the dates are changed throughout the plan, that the go live date automatically adjusts to a Tuesday or Thursday date.

Genevieve P.

Hi @Ayesha Sharif

There currently isn't a way to lock a date cell to a specific day of the week; while you could use formulas, it sounds like you have Dependencies enabled in your Project Settings, so the Start and Finish date columns won't accept formulas.

What I would do in this instance is actually use a helper, hidden column in the sheet. This could use the WEEKDAY function to identify what day of the week the "Go Live Date" is set for.

Then if it's on the wrong day, you could use Conditional Formatting to highlight the cells or you could send an alert email to flag the row.

Cheers,

Genevieve