RYGB formula help
I would appreciate tapping into your vast smartsheet knowledge. I am looking to integrate RYGB balls into a formula but I am having trouble linking them altogether.
My needs are:
- When [Actual Ordered Date] is blank and [Architect Approval] is not blank highlight Red ball. I have the following formula working for the [Architect Approval] is not blank part but having trouble knitting it altogether =IF(NOT(ISBLANK([Architect Approval]@row)), "Red", "")
- I have the formula working for Yellow and Green balls. If [Due Date On Site] is blank, do not highlight any ball. If [Due Date On Site] is in the past and [Item Closed] check box is not checked, highlight Yellow ball. If [Due Date On Site] is within the next 6 days and [Item Closed] is not checked, highlight Green ball. =IF(ISBLANK([Date Due On SIte]@row), "", IF(AND([Date Due On SIte]@row < TODAY(), [Item Closed]@row = 0), "Yellow", IF(AND([Date Due On SIte]@row - TODAY() < 6, [Item Closed]@row = 0), "Green")))
- If [Due Date On Site] is further than 6 days in the future, highlight Blue ball. I haven't got this far as I was pulling my hair out trying to get 1 & 2 to work together.