Hi all, and thanks in advance!
I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3 digits and make the change if it is a 2dig. So TDL-17 will become TDL-017 and TDL-67 will become TDL-067. However no changes will happy to the Account numbers that are already 3 digits.