Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Determine if Date is a Holiday

John Sauber
John Sauber ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

Does anyone have an idea of how to determine if a date is a holiday or weekend (if those are specified in the sheet) in Smartsheet via formula use only?


The equivalent functionality I'm looking for is one row to have a check a box if the date column is a holiday or weekend day. I've tried a lot of "creative" workarounds, but none of them are a generic solution.



  • John Sauber
    John Sauber ✭✭✭✭✭✭
    edited 01/18/17

    Got it...we can even avoid wrapping it in an IF() statement!





  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    That is a beautiful thing John.

    It actually gives me a reason to populate the Holidays portion of the Project Settings.




  • John Sauber
    John Sauber ✭✭✭✭✭✭

    Why not populate those, Craig? We rely on it pretty heavily, so I'm curious what your workaround for non-working days is.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    My teams are typically diverse, or at least they used to be.

    My Czech engineer was in Korea supporting the German simulator.

    The project did not stop for a local holiday, or didn't need to.


    The simulator availabilty was kept in one sheet, the engineers were linked to holidays depending on where they happened to be.


    So 'project holidays' did not really apply.

    A holiday conflict would show up by overbooking a resource across the holiday. That was dealt with with the other PM ("Bob won't be in the office on Monday, do you need support for testing?")


    Now, I travel and work mostly remotely and keep track of which project recognizes which holiday but I typically take local holidays or at least am aware of them.


    And I'm not currently running projects like "traditional" projects. 

    It just doesn't fit with what I or my customers are doing.



This discussion has been closed.