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.
symbol column to add workdays in formula
I want to create a RYG status if a date is late. If it is one workday late it is "Yellow", if it is 2 days late it is "Red" and all other are "Green". The End Date is the due date. The underlined formula will show 2 calendar days but I need workdays/vacation included. Any ideas on how to resolve?
=IF(AND(ISBLANK(completion645), [End Date]645 < TODAY()), "Red", IF(completion645 <= [End Date]645, "Green", IF(completion645 - [End Date]645 < 2, "Yellow", "Red")))