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.

Available Staff for Project

Options
sschwar2
sschwar2
edited 12/09/19 in Archived 2016 Posts

Hello,

 

I wanted to see if anyone had a suggestion how to handle determining what staff is available for a new project when it comes in.


-We have a set list of staff that is available to work on a project

  • -Staff would not ever work on two projects at the same time
  • -We have a column that has a start date/end date for all active projects, with the invididual assigned to the project in a third column.
  • -When we get a new project, we will have the date range and would like to return results of who on our staff is not already assigned to a project during that duration.

 

Thanks for any suggestions,

Steve

Comments

This discussion has been closed.