Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

160 character limit in field (used for sms)

02/28/16 Edited 12/09/19

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.

Comments

  • 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. 

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

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    Lars, 

     

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

    Type in one column, send from the truncated column.

     

    Craig

This discussion has been closed.