Cyclical or Yearly Events

Every year, employees need to update their benefits, complete their performance reviews, etc. How do I add a cyclical event to a project plan?

Visuals are greatly appreciated!

Thanks!

Millie

Answers

  • kowal
    kowal Overachievers Alumni

    hi @Millie_ Aristocrat,

    I always thought aristocrats do not spend their time on communities they just sip their expensive champagne somewhere in Monaco etc. :)

    jokes aside

    You have two options if you want the event to be only one Task then you need to manually date columns and in each use the formula like =[first date event]@row + 14 so it will be after 2 weeks in the next column you will add 28 and so on and so on… but it means a lot of columns to be added.

    you can also add many rows as new events with only one Date column and in each row you can add number you can setup predecessor with a lag of 14 days for example.

    hope this helps.

    Tomasz Kowalski

    Experienced IT PM and the Real Smartsheet Enthusiast.

    Is there anything else we can help you with? - book your time.

    MASA Consult - Your Aligned Smartsheet Gold Partner

    Find us on LinkedIn & Check our Smartsheet Solutions!

    Tag my name: @kowal if you want me to respond :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!