Formula for status update using number of workdays until finish

I need help with a workday formula. I'm trying to get my status bubbles to update automatically based on the number of days until task completion. I've got it to work counting backward using all days with the formula below, but I can't figure out how to only count workdays. Any help is appreciated.

=IF([% Complete]@row = 1, "Blue", IF(TODAY() > Finish@row - 3, "Red", IF(TODAY() > Finish@row - 7, "Yellow", IF(TODAY() > Finish@row - 8, "Green"))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!