Not counting holidays options


On my sheets, I have =WORKDAY([Date Completed]@row, 45). This works fine. I'm confused as to how to deal with holidays and the best way to do it. I can't find any articles that explain how to do a holiday sheet and reference it. Do I even need to do that? I added holidays to the overall account settings. Will that figure in holidays on each of my sheets with the above formula?

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!