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...

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...