How do I...?

Auotnumber and Text in calculated text

Can anyone please explain why this calculated text field formula works when Historic Order Number has a value but not when it's blank. I'm guessing it's something to do with the fact that Historic Order number is a text field whereas Order Number is an autonumber, however I can't find a to string function.

IF({Factory}="Toplink", "TLKNZ", IF({Factory}="Playmore", "PKNZ", IF({Factory}="Colaro", "CKNZ", IF({Factory}="Vithal", "VKNZ", "")))) & IF({Historic Order Number}="", {Order Number}, {Historic Order Number})

3 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Ben shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Ben commented  ·   ·  Flag as inappropriate

    Worked a treat, thanks Derrick! Wasn't aware there was an isblank function.

  • Derrick Kotlus commented  ·   ·  Flag as inappropriate

    Hello Ben,

    You may want to try using the isblank() function rather than the ="" condition.

    IF(isblank({Historic Order Number}), {Order Number}, {Historic Order Number})

    Hope this helps!

    Derrick

Feedback and Knowledge Base