Display RYGB Circles based on dates in multiple columns

R12

Need help trying to display the RYGB circles based on values in other columns.

So, say we have columns that are

ActualStartDateStep1, BaselineFinishDate, CalculatedFinishDate (meaning calculates on the fly as other dates are filled out, re-forecasting the possible finish date), and ActualEndDateStep7. (I have multiple steps with start and end dates across in columns).

....EXPECTED RESULTS: ....

.....If ActualStartDateStep1 is BLANK, symbol = blue (meaning, the line item project has not started yet)

OR

..........If ActualStartDateStep1 is NOT BLANK, then (meaning, the line item project has started)

..........If ActualEndDateStep7 is BLANK, then (meaning, the line item project is in progress)

...............If CalculatedFinishDate = BaselineFinishDate, symbol = green

...............If CalculatedFinishDate < BaselineFinishDate, symbol = green

...............If CalculatedFinishDate is 1 to 3 days after BaselineFinishDate, symbol = yellow

............... If CalculatedFinishDate is 4 or more days after BaselineFinishDate, symbol = red

OR

..........If ActualEndDateStep7 is NOT BLANK then (meaning, the line item project has completed)

...............ActualEndDateStep7 < or = BaselineFinishDate, symbol = green

............... ActualEndDateStep7 within 1 to 3 days of BaselineFinishDate, symbol = yellow

...............ActualEndDateStep7 is 4 or more days after BaselineFinishDate, symbol = red

RYGB column properties is set as Symbol:

Thank you in advance.

R12

I will rename the columns and check if it works.