Give category based on number of digits
tgattsh
✭✭✭✭✭
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...
Tags:
Answers

Hi,
You can use LEN function to count the number of digits. More: LEN Function  Smartsheet Learning Center
Hope this helped :)
Best,
Beata

@SmartWay360 I really appreciate your response. I'll give this a try. Thank you...
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!