Sorting rows ability for sheet and reports with licensed and non-licensed users

Pieter van Gool · 12/09/20

License business uses have ability to sort rows.

Is it so that free licenses holders cannot sort rows in the sheet nor reports, even when they have edit rights?

We have non-licensed folks within our organization that want sort rows, but it is grayed out.

Bassam Khalil · 12/10/20

Hope you are fine, i tried to share sample sheet for non license user with Edit Permission the i login to check if he can sort the row and it's work but you need to right click on column and do it from column menu following screen shot show you which order can non licensed user do.

please read the following article to understand the permission on smartsheet

https://help.smartsheet.com/articles/520100-user-types#nonlicensed

Andrée Starå · 12/10/20

Hi @Pieter van Gool

Do you have any locked rows in the sheet that they are trying to sort?

Although Editors can sort a sheet, they can't sort locked rows. If the Sort Rows option appears unavailable, and you're shared to the sheet with Editor permissions (see Sharing Permission Levels for details), deselect any locked rows before attempting to sort.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

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!

Andrée Starå · 12/10/20

@Pieter van Gool

Happy to help!

To filter, the user has to be either an Admin or Owner of the report.

Make sense?

✅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!

Bassam Khalil · 12/10/20

Hi @Pieter van Gool

Hope you are fine, i tried to share sample sheet for non license user with Edit Permission the i login to check if he can sort the row and it's work but you need to right click on column and do it from column menu following screen shot show you which order can non licensed user do.

please read the following article to understand the permission on smartsheet

https://help.smartsheet.com/articles/520100-user-types#nonlicensed

Andrée Starå · 12/10/20

Hi @Pieter van Gool

Do you have any locked rows in the sheet that they are trying to sort?

Although Editors can sort a sheet, they can't sort locked rows. If the Sort Rows option appears unavailable, and you're shared to the sheet with Editor permissions (see Sharing Permission Levels for details), deselect any locked rows before attempting to sort.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

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!

Pieter van Gool · 12/10/20

Hi Thanks for the immediate support! Just checked the locked columns, thanks for the tip.

However,

how about SmartSheet reports? Top filter options are grayed out and not accessible.

Andrée Starå · 12/10/20

@Pieter van Gool

Happy to help!

To filter, the user has to be either an Admin or Owner of the report.

Make sense?

✅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!

Pieter van Gool · 12/10/20

https://community.smartsheet.com/discussion/comment/271383#Comment_271383

This means, only able upon licensed users. Herewith you answered my question. Thank you.

Andrée Starå · 12/10/20

@Pieter van Gool

Excellent!

You're more than welcome!

Barbara Silva · 07/12/22

Hi @Andrée Starå, I noticed you were very knowledgeable on this topic. Do you know if anything has changed since the above discussion took place? I am experiencing the same problem as described here: I have given free users admin access to a report and underlying sheet, but they are not able to sort or filter the report. I have tried different access levels and unlocking columns. I have even tried not incorporating any pre set-up sorts or filters (as the report owner), to see if it would make a difference. No success. Any tips/insight you can share? Thank you so much!

Sorting rows ability for sheet and reports with licensed and non-licensed users

Best Answers

Answers

Categories