• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Lydon Solutions

Lydon Solutions

Construction Project Management Software Solutions

  • Construction Viz
  • Services
    • Business Consulting
    • Professional Services
    • Microsoft 365 Managed Services
    • Government Agencies
  • Company
  • Events
  • Blog
  • Careers
  • Contact
  • Search
  • Free Consultation
Show Search
Hide Search
Jeff Lydon

Jeff Lydon, the president and founder of Lydon Solutions, has over 20 years of experience in construction project management, project controls, and product management across multiple industries, including civil/environmental, manufacturing, healthcare, and utilities.

What’s the difference between a single-line vs. multi-line text column in SharePoint?

February 28, 2018 Tips from the Field

Learn the key differences between single-line and multi-line text columns in SharePoint – and how to select the right column type for your needs.

There are two types of text columns – single-line or multi-line – that you can add to a SharePoint list or library. It may seem like the difference is obvious. However, the behavior of these two column types in SharePoint is drastically different.

Refer to the table below for a comparison.

Single-line vs. Multi-line Text Column in SharePoint

Single-line Text Column Multi-line Text Column
Maximum Length 255 characters • List = 63,999 characters
• Document library = Unlimited (optional)
Filter and sort in a view Yes No
Reference in a lookup column Yes No
Use in a calculated field column Yes No
Change column type (e.g. choice, number, currency, date and time, single-,or multi-line text.) Yes No
Enforce unique values Yes No
Define default value Yes No
Add rich text (e.g. bold, italics, text alignment, or hyperlinks) No Yes
Enter enhanced text (e.g. pictures, tables, or hyperlinks) No Yes

Which is better: single-line or multi-line text columns in SharePoint?

As you can see, there are significant differences between the two text column types in SharePoint. For example, once you add a multi-line text column, you cannot switch back to a single-line text column. You must instead create a new column.

So which text column in SharePoint is better? We recommend using a single-line text column over a multi-line text column whenever possible. Single-line text fields are the most flexible – so you can do things like later change the information type to add a lookup column, build calculated fields and so on.

Sometimes, however, multi-line text columns are necessary. One example would be a contractor response field in a Submittal Form. Be aware that getting that data back out (e.g. for use in reports, calculations, workflows, etc.) is challenging without custom coding.

Read more about list and library column types and options in SharePoint.

Get more tips and tricks for construction project management professionals

Our Tips from the Field blog series features handy information for construction project managers. Subscribe to our newsletter to get our latest tips and tricks delivered directly your inbox each month.

And be sure to check out our previous tip to learn how to configure required fields in SharePoint.


Related Posts

Microsoft 365 Syntex AI
Microsoft News | August 9, 2023

Let Microsoft 365 Syntex AI Read and Organize Your Construction Images for You

Read More >
sensitivity labels
Microsoft News | July 19, 2023

Redefining Project Permissions with Sensitivity Labels in Microsoft 365

Read More >
Company News | June 13, 2023

Murph 2023 – We took the challenge!

Read More >

Primary Sidebar

Search Blog

Recent Posts

Microsoft 365 Syntex AI
Microsoft News | August 9, 2023

Let Microsoft 365 Syntex AI Read and Organize Your Construction Images for You

sensitivity labels
Microsoft News | July 19, 2023

Redefining Project Permissions with Sensitivity Labels in Microsoft 365

Company News | June 13, 2023

Murph 2023 – We took the challenge!

Microsoft News | April 25, 2023

The end of an era with Microsoft SharePoint Server 2013

Microsoft 365 Loop
Microsoft News | April 14, 2023

Microsoft 365 Loop will change your work day. Are you ready?

Company News | April 7, 2023

Contractor Access Has Never Been Easier with Lydon Solutions’ Microsoft 365 Contractor Portal

Footer

About

Lydon Solutions is a WBE consulting group specializing in construction project management software solutions using Microsoft SharePoint. Learn more >

Products & Services

  • Construction Viz
  • Professional Services
  • Business Consulting
  • Microsoft 365 Managed Services
  • Government Agencies

News & Events

  • Events
  • Blog

Company

  • About
  • Careers
  • Contact Us

Join our Mailing List

  • This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
  • This field is for validation purposes and should be left unchanged.
Lydon Solutions

© Lydon Solutions

  • Sitemap
  • Privacy
  • Cookies
  • Terms of Use
  • Disclaimer