Determine if Date is a Holiday

John Sauber

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

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

 

Checkbox=networkdays(Date1,Date1)

 

Duh.

J. Craig Williams

That is a beautiful thing John.

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

Almost.

 

Craig

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

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.

 

Craig