Formula to see if someone is available
Landon W
✭✭
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.
Tags:
Comments
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!