Limit Size of Entry on a form

I tried to search for this but was not able to find it. I have a form that I has one of the entries that I want to collect is nickname....but I can only display 8 characters....

So how do I limit the entry to restrict it to be only 8 characters?

Today I am preloading the field with XXXXXXXX hoping that they will read the instructions and limit it themselves.....thanks. Tom

Find more posts tagged with

Forms

Services

Comments

Unfortunately you cannot limit what is entered on a form. You can however use a checkbox column with

=IF(LEN([Nickname Column Name]@row) > 8, 1)

It will check a box if the characters are more than 8. You can then create an update request to send out if that box becomes checked.

That's a great idea... like a "Thank you for your submission but we noticed that your nickname exceeded the 8 characters. Please update the nickname to match that character limit." Along with that cell's details.

You will have to capture users to do that though or ensure they submit one in their form submission.

Hi Tom,

I agree with Mike that this is a great suggestion for a feature. You can submit this to our Product team by clicking on the "Submit Product Enhancement Request" link on the right sidebar. We love hearing input like this from our customers.

This could be something like: "Limit characters during form entry for certain fields" and/or "Data validation to ensure correct data entry".

Thanks!

Ian

Smartsheet Support

You guys are the best...thank you.

I already use the alerts and update requests...and I will use this as a "work around". Tom

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…