Formula to check the Unit availability

Joseph Aloysias
Joseph Aloysias ✭✭✭✭✭
edited 11/21/22 in Formulas and Functions

I would like to check the Unit availability, we want to check the start date & end date and U1, U2, U3, etc. and unit availability column should provide whether it's available/nonavailable to use for other projects

Is there any formula that can do this?

Also when a unit is assigned for a particular project for a particular duration it shouldn't be available for other projects


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!