Proceeding Zeros to an already existing column.

Hi, I'd like to add Proceeding zeros to an already existing column

Currently there are over 2000 rows in the, with a varying number of digits from 1-4. I'd like them all to be a 4 digit number.

So if the column has an entered number of 1, I'd like the proceeding zeros to make it a 0001

or 501, but 0501.

Is this currently possible?

Find more posts tagged with

Accepted answers

sharkasits

I don't think you can update the column, but you can create a calculated field to do it. Would that work?

I was just playing with this the other day and this is what I came up with.

=LEFT("0000", 4 - LEN([column]@row)) + [column]@row

All comments

sharkasits

I don't think you can update the column, but you can create a calculated field to do it. Would that work?

I was just playing with this the other day and this is what I came up with.

=LEFT("0000", 4 - LEN([column]@row)) + [column]@row

C. Ruiz

https://community.smartsheet.com/discussion/comment/356718#Comment_356718

Thanks again for your help! That worked.

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.