LEN Function- Count Incorrect

I am trying to get a character count from two rows in a content calendar " Copy" + "Link". I have it adding up correctly, except I am getting a value of 1 in the blank cells.

Formula is: =LEN([Social Copy]@row + Link@row)

Screenshot below

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!