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


  • Hi Faran, 


    Smartsheet has a Resource Management tool and views to assist you with this set-up. I've sent you a follow-up email to connect and help you set this up. Looking forward to speaking with you!




    New Accounts Specialist



This discussion has been closed.