Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

can you set up weekly reminders for a date that has gone in the past (off a cell in the sheet)

Im looking to set up a reminder automation that will send out reminders on a weekly basis if tasks are not completed by a certain date. In my sheet there are numerous dates and they are pulled in from formula (dynamic) meaning that i need to pull it off a specific column / cell in the sheet. although the automations allow you to set them up to run daily/weekly/monthly from a certain day of the week and specific date, i cant see an option to set it up weekly from a certain date cell. does anyone have a solution around that? possibly using alternative sheets or something?

Thanks in advance!

Best Answer

  • Community Champion
    Answer ✓

    Yes. This formula will essentially output a date that is 7 days past [Start Date]@row and will increment every 7 days.

    So basically it will output the date 1 week from the original date. Once that first week has passed, it will output a date 2 weeks from the original date. Once two weeks has passed, it will output the date 3 weeks from the original date, so on and so forth.

    You have two options to only have it running when something is not complete, you can either wrap it in an IF statement

    =IF(Status@row <> "Complete", date_output_formula)

    Or you can include it as a condition within your reminder automation.

Answers

Trending in Smartsheet Basics