How to count characters in cell
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?
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
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.
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.