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)
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.
-
Lars,
You could also send only the first 160 characters using the LEFT formula.
Type in one column, send from the truncated column.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
