Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Resource Planner with Location & Dates

edited 12/09/19 in Archived 2016 Posts

Dear All, has anyone created a resource planner that shows day by day location such as onsite, offsite, vacation, public holiday etc.?


I would like for two columns with the resource name and the resource role and then the rest of the columns should be the calendar with the column showing the day and date for the month.


An example of what I have in Excel but would like in smartsheet is below so hopefully you can understand what I am trying to achieve. The sheet should also have a key to signify what the colours of the cells mean.


Thanks in advance.



Resource Planner.png


This discussion has been closed.