Blank values are not calculated as expected

[vally57]

Hi Experts,
i have written the calculated column if([ship date] =blank(),1,0), but even [ship date] is blank , i'm getting blank instead of 1.
only few of blank values are considering  and showing 1, others displaying blank.
can you guys help me on this.
TIA

[Anonymous · Accepted solution]

Hi @vally57 ,

In my test, if Delivery No and Ship Date are two fields in the table. Then blank() acts the same as isblank() provided by @sjoerdvn .

Column1 = if([Ship Date] = BLANK(),1,0)

Column2 = IF(ISBLANK([Ship Date]),1,0)

So in the screenshot you provided, what exactly are Delivery No and Ship Date referring to? Please provide the relevant test data and describe it.

Best Regards,
Adamk Kong

[sjoerdvn]

 if(ISBLANK([ship date]),1,0)