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.

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

  • ✭✭✭✭
    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

  • ✭✭✭✭
    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

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

  • Any updates on this? Disappointing that this functionally is not available—but not surprising.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions