Formula to see if someone is available

Landon W
Landon W ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to build a formula that references another sheet. The goal is to be able to see if someone is working on a project currently. In the reference sheet we have the start date and end date and the Talent's name. So, I am guessing it is going to have to be a IF/AND formula and the conditions will need to include the person's name but then I am stumped. I can't figure out how to get the formula to read the date range or if it is even possible. Any help at all would be really appreciated. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!