Give category based on number of digits

I'm hoping to find the best way to write a formula based on the number of digits. I have column called "Area" which contains number of 1, 2, or 3 digits. I need to write a formula in another column to give a designation to the area, either "R" for all 1 and 2 digit numbers and a "C" for all 3 digit numbers.

Any help from this amazing community would be appreciated. Thank you...

Find more posts tagged with

Formulas

Accepted answers

All comments

SmartWay360

Hi,

You can use LEN function to count the number of digits. More: LEN Function | Smartsheet Learning Center

Hope this helped :)

Best,

Beata

tgattsh

@SmartWay360 I really appreciate your response. I'll give this a try. Thank you...

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.