Full year calendar - accounting month/quarter end

edited 12/09/19 in Smartsheet Basics

Hi All!


I am at a loss at how to even start this design. 


I have approximately 15 tasks that occur every month on the same BUSINESS day 

I have another 5 tasks that occur on the same business day every quarter.


I would like to see this in a calendar view


Any suggestions on how to build this? 


ie: Formula for the 'due date' that will give me business day (which would exclude holidays/weekends)

A way to clearly delineate monthly vs quarterly tasks (perhaps just a color?) 

and how to format this on the excel sheet so that it shows up on the calendar view clearly? 



Throughout the year, there will likely be additions to the process, so I need to be able to add tasks as the year progresses