Need help with IF formula

Options

Hello!

I want to use an RGB Symbol formula that first looks at a 'Completed' cell and if "checked" returns green, but if not checked it moves on to look at a "Date" column to return RED, YELLOW, BLUE or Upcoming. Here is my current formula:

=IF(OR(COMPLETED@row = 1, "Green")), IF(DATE@row < TODAY(), "Red", IF(WEEKNUMBER(DATE@row) = WEEKNUMBER(TODAY()), "Yellow", IF(WEEKNUMBER(DATE@row) = WEEKNUMBER(TODAY()) + 1, "Blue", "Upcoming"))))

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!