Forum Discussion
Solved
Set max character limit in Lists multi-line column
Hello, I have a multi-line column in a Microsoft Lists list and users are putting too much text in it. I would like to set a maximum character limit to prevent this (for example 500 characters)....
laser132217 the only out-of-the-box way to do this that I know of is to:
- create the column as a single line of text column
- set the validation settings to =LEN(yourcolumn)<500
- change the column type to multiple lines of text
The validation will still be applied even though it is now a multiple lines of text column.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott I too would like to do this, I've tried adding the other columns to this formula, adding additional formulae, but can't get it to work - Riza24 did you find out how?
found out how:
=AND(LEN([March Update])<500,(LEN([Jan Update])<500),(LEN([May Update])<500),(LEN([July Update])<500),(LEN([Sept Update])<500),(LEN([Nov Update])<500))