1

I have this formula working fine, but when field VD (which is a date field) is empty, it adds a funny date to it. How can I get it to us the VD field when populated, but if its empty just display TBC or NULL or something like that.

=CONCATENATE([ID],"|",[VT],"|",TEXT([VD],"dd/mm/yyyy"),"|",[Spec],"|",[Hub],"|",[Name])

help is appreciated :-)

1 Answer 1

4

Check for blank values: i.e.

 (IF(ISBLANK([VD]),"",TEXT([VD],"dd/mm/yyyy")))

 =CONCATENATE([ItemID],"|",[VT],"|",(IF(ISBLANK([VD]),"",TEXT([VD],"dd/mm/yyyy"))),"|",[Spec],"|",[Hub],"|",[Name])
1
  • 1
    @Davejones please don't forget to set the answer as accepted it's the true sign beside the answer! Feb 9, 2018 at 13:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.