Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to write an expression using a date column but the ISNULL doesn't seem to be working. Can someone please tell me what I doing wrong with the below?
=IF(DATE ISNULL,'Piece In','Piece Out')
Thank you in advance.
You should use:
=if(IsNull(Date),'Piece In','Piece Out')
You should use:
=if(IsNull(Date),'Piece In','Piece Out')
May be try this
If(Len(Trim(DATE)) = 0, 'Piece In', 'Piece Out')
or
If(IsNull(DATE), 'Piece In', 'Piece Out')
Thanks