Automated Workflow Monthly Archiving


Hi everyone,

I am attempting to set up a specific automated workflow to perform archiving.

Normally this wouldn't be an issue however I'm using this function to try and have a chart on the dashboard to display the current months data and 11 months prior - so it is a "rolling" chart so to speak.

The nature of my current sheets means that for example, come first of January 2021, I want to move rows between first and last day of January 2020 into an archive sheet. Then come first of February 2021, rows between first and last day of February 2020 into an archive sheet, and so on.

I am using a date field to try and perform the conditional logic in the automated workflow section however finding that it just doesn't quite work right. See below for example. 365 days here is not really correct, it would need to be something closer to 335 days (30 days in a month) - the main issue here being the different months have different numbers of days. not to mention leap years.

It is critical in my case to move all the data from the month so that my chart doesn't show data for January across two different years, for instance.

Please advise if this is doable using automated workflows in this case or whether I need a different approach. Any comments appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!