Help with adjusting a formula


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"))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!