formular IF and or

Options

Hi Experts,

I use a formula on different sheets and it works on 4 sheets but on this one it's shown the wrong results. I could not find the mistake. Could you please have a look.

Here is my formula:

=IF(AND(OR([CR0 Planned ex-factory date AC-T samples]@row = "", [CR0 Actual ex-factory date AC-T samples]@row = ""), [CR0 AC-T sample needed?]@row = "yes"), "Yellow", IF(AND([CR0 Actual ex-factory date AC-T samples]@row < DATE(2023, 1, 18), [CR0 AC-T sample needed?]@row = "yes"), "Green", IF(AND([CR0 AC-T sample needed?]@row = "", [CR0 Actual ex-factory date AC-T samples]@row = ""), "not needed", IF(AND([CR0 AC-T sample needed?]@row = "yes", [CR0 Actual ex-factory date AC-T samples]@row <> "", [CR0 Planned ex-factory date AC-T samples]@row <> "", [CR0 Actual ex-factory date AC-T samples]@row >= DATE(2023, 1, 18)), "Red"))))

And the result: But in the yellow frame cells the result should be a yellow dot. And if I put in a date in "CR0 Actual ex-.....) the result is an empty cell.

Thanks for your help!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!