Formula to add leading 'zero' to IDs

I have used these formulas individually and they work, but need to combine as an OR statement

=IF(LEN(MSID@row) = 2, "00" + MSID@row, MSID@row)

=IF(LEN(MSID@row) = 3, "0" + MSID@row, MSID@row)

=IF(OR(IF(LEN(MSID@row) = 2, "00" + MSID@row, MSID@row), LEN(MSID@row) = 3, "0" + MSID@row, MSID@row))

But the combined formula gives an Incorrect Argument Set, any ideas.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!