if date field is not blank return a number
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...
Forum Discussion
Try this
If(not isnull([Project Start Date]) , [Cost] * 0.3, 0)
If(not isnull([Project Start Date]) , [Cost] * 0.3, 0)