Help with adjusting a formula

Clark Everson

So the formula below is used to determine the colors of the dots. However, I need it modified so that for Blue Dots, they will be Blue based on the current condition already there, or if the start date or finish date are empty. I was unable to figure this out on my own so thought I would post it here

=IF(OR(Status@row = "Complete", [% Complete]@row = 1), "Green", IF(Finish@row <= TODAY(), "Red", IF(Finish@row > TODAY(7), "Blue", IF(Finish@row >= TODAY(), "Yellow"))))

Paul Newcome

Lets try some rearranging then...

=IF(OR(Status@row = "Complete", [% Complete]@row = 1), "Green", IF(OR(Finish@row > TODAY(7), Finish@row = "", Start@row = ""), "Blue", IF(Finish@row <= TODAY(), "Red", IF(Finish@row >= TODAY(), "Yellow"))))

Paul Newcome

Give this a go...

=IF(OR(Status@row = "Complete", [% Complete]@row = 1), "Green", IF(Finish@row <= TODAY(), "Red", IF(OR(Finish@row > TODAY(7), Finish@row = "", Start@row = ""), "Blue", IF(Finish@row >= TODAY(), "Yellow"))))

Clark Everson

Just tried this and the blank ones stayed Red

Paul Newcome

Lets try some rearranging then...

=IF(OR(Status@row = "Complete", [% Complete]@row = 1), "Green", IF(OR(Finish@row > TODAY(7), Finish@row = "", Start@row = ""), "Blue", IF(Finish@row <= TODAY(), "Red", IF(Finish@row >= TODAY(), "Yellow"))))

Clark Everson

That worked! Thanks so much!

Paul Newcome

Great! Happy to help! 👍️