Health Status Formula RYGG
I am new to smartsheets and I am having difficulties setting up basic Health Formula with RYG+Gray bullets based on Status (Cancelled, Delivered) and Due date column.
GRAY when Status is Cancelled
RED when Status is Delivered, but after Due date
GREEN when Status is Delivered till and on Due date
YELLOW when none of the above applies
Could anybody help me out with this? Thank you!
Help Article Resources
Check out the Formula Handbook template!