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
David Friesen
✭✭✭
Hi,
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")))
Thank you.
Comments
-
Hi David,
Try using NETWORKDAY in your formula:
...IF(NETWORKDAY(completion645, [End Date]645) < 2, "Yellow"...
More on this here: https://help.smartsheet.com/function/networkday
This discussion has been closed.
