if date field is not blank return a number

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

Hi

I'm trying to create a formula to return a number if a date field is not blank. 

I have 3 fields : Start Date, Cost and Gateway Cost 30%.

The formula is in the Gateway Cost 30% field and needs to be:

"if the Start Date is not blank then return 30% of the Cost "

I tried the formula below in a numeric formula field but it is returning errors.  Any thoughts?

If([Project Start Date]>0,[Cost]*0.3,0)

Thanks

Sarah

Photo of Sarah

Sarah

  • 20 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
Try this

If(not isnull([Project Start Date]) , [Cost] * 0.3, 0)
Photo of Sarah

Sarah

  • 20 Points
Perfect - exactly what I was looking for.  Thank you.