Can Character limits be added to text fields, specifically for a form?

I saw the post from 6/18/21 here: https://community.smartsheet.com/discussion/80492/can-character-limits-be-added-to-text-fields

However, the formula

=IF(Text@row >= 50, "Limit Reached. Please use less characters")

is creating an #UNPARSEABLE error.

Tags:

Best Answer

  • edapel
    edapel ✭✭✭✭
    Answer βœ“

    Hi Susie,

    Currently it is not possible to have a character limit in the text field of a form. They are limited to 4000 characters including spaces currently, but you cannot make it smaller. This is a good thing to put an enhancement request in, I know I would love to see this and I'm sure others would too.

    Ed

    If this comment helped you, please help me and help others by using the buttons below if you found itπŸ’‘Insightfulor❀️Awesome!

    Hope you have a great day!!

    Ed

Answers

  • edapel
    edapel ✭✭✭✭
    Answer βœ“

    Hi Susie,

    Currently it is not possible to have a character limit in the text field of a form. They are limited to 4000 characters including spaces currently, but you cannot make it smaller. This is a good thing to put an enhancement request in, I know I would love to see this and I'm sure others would too.

    Ed

    If this comment helped you, please help me and help others by using the buttons below if you found itπŸ’‘Insightfulor❀️Awesome!

    Hope you have a great day!!

    Ed

  • Crew28
    Crew28 ✭✭

    A setable character limit on an input form would be very useful, and would make the document builder more reliable in automation without having to put another step in to monitor / administer the process.

  • daniel.hawks
    daniel.hawks ✭✭

    Any updates on this? Disappointing that this functionally is not availableβ€”but not surprising.

  • KRR
    KRR ✭✭

    I would likewise appreciate an update on this. We have forms for which a hard character limit is necessary on entries to prevent truncation when the entry is passed to a display ad as a title. Lack of a character limit will require manual rejection of some entries for being too long, and a resultant email chain.

    Most form tools had that functionality decades ago, why does this not have a simple character limit variable on text boxes?

  • SP11
    SP11 ✭

    I would also like to have this function. This is basic database management requirement and I'm surprised that Smartsheet doesn't have this function.

  • nonova
    nonova ✭

    Agreed, this is necessary for my use case and sure many others will find it useful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!