LEFT Function
I want to add a "0" to the left of any number with just 5 digits and just duplicate any number with "H" in front.
Best Answer

Ok. Let's try this instead:
=IF(LEFT([Column2]@row) = "H", [Column2]@row, "0" + [Column2]@row)
Answers

Try something like this...
=IF(LEN([Column2]@row) = 5, "0") + [Column2]@row

That works great for the example I provided. One exception and rather important that I failed to list, a standard five digit number could have an extension, like "XA", ie.45232XA, making length 7. I was working with contains to duplicate when includes a "H". Thank you for the quick reply.

Ok. Let's try this instead:
=IF(LEFT([Column2]@row) = "H", [Column2]@row, "0" + [Column2]@row)

Thank you Paul, I added the OR and it seems to work for all

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!