Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this.
For example I have a task that needs to be done the Monday following all major holidays (Christmas, 4th of July, Memorial Day, etc). I also have some that need to be completed every quarter so I would make the deadline the last workday of a quarter. I want to automate the deadline date to change automatically based on the frequency I set.
Is there an easy way to format this or any recommendations you would have when creating this sheet? Thank you!