how can i calculate through a formula the availability of a person for the current week considering the range of all the start dates and end dates of the jobs in which he is envolved?

=IF(WEEKNUMBER([Start Date]@row) = WEEKNUMBER(TODAY()), "not available ", IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), "not available", "available"))

actually i use this formula but the problem is that this formula works just with one start date and one end date, while i have to consider a range of start dates and end dates


@Andrée Starå


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!