Trying to create a formula for multiple IFs on the same report

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I am trying to create a Row colorization formula for multiple IFs on the same report:

If([Due to Production] < Today(),"pink")

If([Status] = In Production, "Green")

Is it possible to create a formula using two different fields? Any help appreciated! Thanks!!

Photo of mkosek

mkosek

  • 918 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 570 Points 500 badge 2x thumb
Try this:

If (

[Status] = "In Production", "Green",


[Due to Production] < Today(), "Pink"

)
Photo of mkosek

mkosek

  • 918 Points 500 badge 2x thumb
This formula only works for the second part, [Status] = "In Production", "Green")
Photo of Xavier Fan

Xavier Fan, Champion

  • 570 Points 500 badge 2x thumb
I edited the formula above - try it again.  I had the "<" flipped the other way than you did for "Pink".

Also - I put the "Green" status first, since I think the intent is that if [Status] = "In Production", show "Green" regardless of whether the "Pink" condition also applies.