Formula Help - Return Min if no Null values present

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
I have 2 Min formulas where when one is Null in another formula, it returns the other value.

I need the second Min formula to only calculate when a specific date field has a value ("[End Date (Report Specific)]").


Delivery Deadline Calc1 Formula
Min ([Delivery Deadline1], [Delivery Deadline2])

Delivery Deadline Calc2 Formula
Min ([Delivery Deadline3], [Delivery Deadline4])


Report Deadline Formula
Nz([Delivery Deadline Calc2], [Delivery Deadline Calc1])

Photo of Jennifer Peterson

Jennifer Peterson

  • 296 Points 250 badge 2x thumb

Posted 1 month ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
Is this what you want

Delivery Deadline Calc2 Formula
IF(not IsNull([End Date (Report Specific)],
Min ([Delivery Deadline3], [Delivery Deadline4]))
(Edited)
Photo of Jennifer Peterson

Jennifer Peterson

  • 296 Points 250 badge 2x thumb
Yes! Thank you! I did not realize I could use "not" in that line. That worked perfectly.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,766 Points 50k badge 2x thumb
"not" a problem, my pleasure.