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})
Ben shared this idea · May 13, 2015
Comments
2 comments
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
Worked a treat, thanks Derrick! Wasn't aware there was an isblank function.
Please sign in to leave a comment.