Triggering when Start date Reached or Between Start Date & End Date Entered

Options

Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Options

    Do you need 2 sheets or could you report on sheet 1 between the dates?

    If you need two sheets, maybe you could use the Modified Date and a helper column to tick if the modified date is between the Start and End date. Then if the helper column is set to 1 (ie it ticks) then this could be the trigger for the copy row automation?

    I'd be happy to explain further if you'd like to reach out to me.

    Kind regards

    Debbie

  • Vinton Douglas
    Options

    Hi Debbie,

    Many thanks for responding. Your suggestion with the modified date is a great idea . I would like to reach out to you for further explanation. Thanks in advance.

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Options

    Sure @Vinton Douglas

    My email address is debbie.sawyer@smarterbusinessprocesses.com - pop me an email and I'll set up a zoom to chat some ideas through with you.

    Kind regards

    Debbie

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!