Availability Formula

Filippo01 ✭✭
edited 08/31/22 in Formulas and Functions

I/m actually using this formula to check the current week availability of the employees considering all the jobs' dates of the year in which they are involved:

=IF(AND(WEEKNUMBER([Start Date]3:[Start Date]11) = WEEKNUMBER(TODAY()), WEEKNUMBER([End Date]3:[End Date]11) = WEEKNUMBER(TODAY())), "not available", "available")

the problem is that the formula works only with a single start date and a single end date, doesn't work with the all range of dates

someone can helps me?



  • Tomasz Giba
    Tomasz Giba ✭✭✭✭✭

    Hi @Filippo01

    I may be able to help you with this. However the solution for this problem will require a little more then a single formula and it's depended of how you have your sheets constructed.

    If you want to proceed with creation of this solution then this will require to share some screenshots and more detailed description of your system.

    Let me know if you are interested and we will go from there.


    Tomasz Giba

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!