Need help correcting my IF/AND conditional formula: If ([30 Day Alert]0,"pink")

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

Need help correcting my IF/AND conditional formula to colorize only those fields where 30 Day Alert or Date Due is after Today AND the remaining balance is above $0. Currently the remaining balance portion isn't implemented

If ([30 Day Alert]<Today() or [Date Due]<Today() and [Remaining Balance]>0,"pink")

Photo of Joy

Joy

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
try this

If(

(Today() > [30 Day Alert] or Today() > [Date Due])


and


[Remaining Balance]>0,"pink")