Is there a work around for hitting cell maximum character count?

Christine MacKinnon

Our team tends to max out the character count in a cell. Does anyone have any solutions for making the best of this situation?

Julie Fortney

What types of cells are you experiencing this issue with? We've had this happen in "Notes" columns, so what we'll do instead is direct the team to use the row Conversations, and change the "Notes" column into a "Latest Comment" column type.

If it's another use case, I would figure out a way to split it into separate columns. Let's say you have a "Project Description" column that people tend to get wordy with. Maybe you split that into separate columns such as:

System Type

Options Selected

Site Specifics

etc.

Christine MacKinnon

Hi Julie-

this is helpful- thank you. It is for notes. The engineers are getting the notes that end in …". I like the idea of making the column the latest comment. Is this a way to program this or does your team do it manually?

Thank you!

Julie Fortney

It's a column type you can select. It's a pretty cool feature:

Christine MacKinnon

That's amazing! Thank you!

Christine MacKinnon

Follow up question- After continuing to dig, this is what is happening. They are using the lastest comment column to auto populate a sheet summary. That sheet summary is feeding another document and the document that is getting fed by the sheet summary is showing the "…"

Thoughts?

Julie Fortney

If they need to accommodate more text, they'll need to create additional fields to contain it.

Christine MacKinnon

thank you for the assistance Julie!