Count charcaters with blank space

Platform discussions Special workflows & use cases
1

We have a board set up for social media publishing and I recently realized our formula for tweets isn’t working properly.

The formula: if(LEN({Twitter Copy})<=280,"✅", "❌")

The problem with this formula is that white spaces aren’t accounted for, but Twitter does count them.

What would be the best way to go about this?

2

Hi @edan - I assume this is a Text or Long Text column? If so LEN() will pick up the spaces. I tested it in my environment, and it is the correct value.

I dont see any reason why that wouldnt work? Can you confirm the column type.
Mark