How to count characters in cell

01/12/22
Answered - Pending Review

Hello

I am trying to figure out how to count characters in a cell. I am using the LEN formula =LEN(name of column) but i am getting the unparseable showing in cell every time i try?

Answers

  • Kelly MooreKelly Moore ✭✭✭✭✭

    Hey @Charactercounthelp

    You need to tell the function which particular cell in the column to count. You do this by adding '@row' at the end of the column name

    =LEN(column@row)

    The @row must be written in lower case. The easiest way to make sure you have the correct syntax for the column name is to type =LEN( then click into the desired cell. Smartsheet should add the correct syntax, assuming the formula and the desired cell are different columns but within the same row.

    Kelly

Sign In or Register to comment.