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
David Friesen ✭✭✭
edited 12/09/19 in Archived 2017 Posts


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.


This discussion has been closed.