Skip to main content
Question

if date field is not blank return a number

  • June 27, 2016
  • 0 replies
  • 161 views

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

This topic has been closed for replies.

Try this

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

  • Author
  • Quickbase Alumni
  • June 27, 2016
Perfect - exactly what I was looking for.  Thank you.