Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Cell Restrictions
Options
Hi there
Does anyone know whether you can add restrictions to cells (or columns/rows) to specify the number of characters/words used?
For example, i'd like to restrict some cells to a maximum of 30 words, to ensure people don't input excessive descriptions.
thank you!
Tags:
Comments
-
Katie,
The cells/fields cannot be restricted, however if you are using the Web form for data entry then the form text box can be set to a specific number of lines.
You could also use an indicator column that counts the number of letters { Len() }and displayes it. Add to this conditional formatting to change colour as they approach your limit and turns red when exceeded,
-
That's really helpful, thank you.
-
You are welcome.
This discussion has been closed.
