Formula to add leading 'zero' to IDs

Kevin7859

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.

Find more posts tagged with

Accepted answers

Anjanesh Vaidya

Hi Kevin7859,

You can try the below formula to combine both the conditions as mentioned.

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

I Hope it will work.

Thank You!

Anjanesh Vaidya

All comments

Anjanesh Vaidya

Hi Kevin7859,

You can try the below formula to combine both the conditions as mentioned.

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

I Hope it will work.

Thank You!

Anjanesh Vaidya

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.