Limit Size of Entry on a form

tom55166 ✭✭
edited 12/09/19 in Smartsheet Basics

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



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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.

  • IanN
    IanN Employee

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



    Smartsheet Support

  • tom55166

    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