Resource Planner with Location & Dates

Faran

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.

 

 

Hayley New Accounts Specialist

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!

 

-Hayley

 

New Accounts Specialist

Smartsheet