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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 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!