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

edited 12/09/19 in Archived 2016 Posts



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,



This discussion has been closed.