# Help with adjusting a formula

Options

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

Tags:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• Options

Just tried this and the blank ones stayed Red

• ✭✭✭✭✭✭
Options

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

• Options

That worked! Thanks so much!

• ✭✭✭✭✭✭
Options

Great! Happy to help! 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!