If Work Week Is Next Week


How do I write the formula to show *Expcd Work Week if work week is next week based on the three options?




  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    I'm not quite following what you need, but WEEKNUMBER function might be able to help you. Like, if you are trying to determine if a date is next week, you could do something like


    Then if you put that into a checkbox column, it'd check the box if a date referenced is next week.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!