Formatting IP Addresses
I am trying to import an Excel spreadsheet that has a formula to format a column of IP addresses based on the column to the left of the formula. It works in Excel but it appears that SmartSheet does not have the same "Text" function option -- the ability to establish the format of the string.
Trying to take 10.60.2.113 in one cell and have it create a new cell in another column with 010.060.002.113 so that this column will sort the addresses 'properly'
Help Article Resources
Check out the Formula Handbook template!