Tonumber error

[moshood]

Hi All

Im trying to write: if the date column is empty/null then 0 otherwise 1 but this error keeps popping up. 

it will only read the formula if the the 0 and 1 are in brackets but i then get the tonumber error. 

Can you let me know your views on what i am doing wrong

Thanks again 

[bpatel · Accepted solution]

hi @moshood,

try this if isnull([Lease start date]) then 0 else 1 endif

hope this helps!

[moshood]

Thank you. This has worked. is there a reason why this worked and the other process did not ?

[bpatel]

@moshood ,

your thought process was spot on it was a just a matter of formatting the formula correctly. you can start off a formula with isnull() you don't need to have [field]=

you could also have done it like this (which is like your original formula). i would say the key thing to remember is that isnull() is a function and null() can be treated like a value. hope this helps!