Can I Prevent Sorting of a Sheet

I have a sheet that I do NOT want anyone to be able to sort. However, they do need to add content and comments (edit) to the sheet. Is there a way to do this?

If there isn't and the editors will be able to do this then I have another question. How can I post or pin something to the top of sheet to let people know not to sort the sheet? I know I could add it to the sheet comments but people won't look there.

Thoughts?

Thanks,

Jeana

Find more posts tagged with

Accepted answers

Andrée Starå

Hi @Jeana

Something that might help could be to add an auto-number column or similar always to have a way to go back to the correct order.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

RossL

You could have them use a report that way if the sort it it will not sort the base sheet.

Jeana

True, and there are reports on this as well as Filters available. Still, there's that one person (who does need to edit this sheets) that will try to sort it and there goes a few hours of my time putting things back in order. Happened this week. :-/

Andrée Starå

Hi @Jeana

Something that might help could be to add an auto-number column or similar always to have a way to go back to the correct order.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Jeana

Andrée,

Good idea! I think I'll set that up just in case. :-)

Thanks,

Jeana

Andrée Starå

@Jeana

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Laura Bell

Has this feature been added?

Andrée Starå

Hi @Laura Bell

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Michele Rosenberg

Hello @Andrée,

I have an auto-number on but it doesn't sort in numerical order it sorts by all digits of the number (1, 10, 11, 5, 50, etc). Is there a setting to help this?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.