How to create some kind of exception for holidays?

Alex Savin

I've specified the holidays for the project.

The project involves international teams. Some tasks assigned to the certain team, some tasks assigned to another team. And the holiday suitable for one team isn't suitable for another one.

And I can't specify the task Start Date on holiday for the team which doesn't have the holiday at that day.

It seems that smartsheet has only global configuration for holidays.

Could you please advice whether the solution exists or not?

Paul Newcome

You would need to turn off dependencies and use formulas to replace how everything works. I can say from experience that factoring in holidays can get very tricky, requires a handful of "helper columns" and will bog down your sheet very quickly.

Paul Newcome

You would need to turn off dependencies and use formulas to replace how everything works. I can say from experience that factoring in holidays can get very tricky, requires a handful of "helper columns" and will bog down your sheet very quickly.

Alex Savin

Thank you for the clarification, Paul.

Paul Newcome

Sure thing. 👍️