Formula for =text(A1, "000000-0" ?

Mtmoroni

I am looking for a similar Smartsheet formula that excel has that takes text from a column/cell; say 12345-7, and changes to "0012345-7" - forcing the cell to be in a specific format.

Excel uses "=text(A1, "0000000-0")

BullandKhmer

Yours would would be ="00"+(row)@row

you can also use +""+ +"-"+ and =JOIN( functions.