160 character limit in field (used for sms)

Lars Einarsson Mansén

Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.

Erik Rucker

There's no way to enforce a character limit today, but you could set the sheet up to warn you if you type too much text.  You might create a column to measure the length of the SMS field with the formula =len(<sms field>).  Then you could set a conditional format on the SMS field to turn red when the character count goes over 160. 

Lars Einarsson Mansén

Very good. This helps us with at least 75% of the functionality we were after, thanks.

J. Craig Williams

Lars, 

 

You could also send only the first 160 characters using the LEFT formula.

Type in one column, send from the truncated column.

 

Craig