Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Is There A Way To Set A Character Limit?
I am hoping to set a character limit within a SmartSheet form when people use the form for submitting something. Is this possible?
Best Answer
-
hi @Nicole J ,
i do not think there is. Maximum you can put in one cell in smartsheet is 4k characters but that's it.
you can later use formula to remove too much data from the left and from the right but i do not think it's possible to block putting data in the cell.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Answers
-
hi @Nicole J ,
i do not think there is. Maximum you can put in one cell in smartsheet is 4k characters but that's it.
you can later use formula to remove too much data from the left and from the right but i do not think it's possible to block putting data in the cell.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.4K Get Help
- 465 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.4K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I have a source sheet of different items, rolling out on different dates for different stores. I am creating a target sheet of a rollout of one specific item. I want the target sheet to list all the s…
- = "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm h…
- Hello, I'm hoping someone can help me figure this out. I want to multiply the first three columns, with the total showing in Total Number of Delivered Training Hours. However, that field keeps showing…