admin access - cannot delete columns?

Jeni Day

A coworker that has admin access to a sheet I own cannot delete a column. I believe admin access allows you to do so. Has that changed?

 

J. Craig Williams

It used to.

I just deleted a column from a sheet in one of my customer's account. I'm an admin but not licensed. (Wrong sheet - testing now)

 

This indicates I should not have been able to do that.

From https://help.smartsheet.com/articles/1155182-sharing-permission-levels

 

Admin

All functions available to Editors, and the following:

• Insert, rename & delete columns, change column properties (licensed Admins only)
• Move columns within the sheet (licensed Admins only)
• Share saved filters so that others can use them (Team plan or higher)
• Hide/unhide columns (licensed Admins only)
• Lock/unlock columns & rows
• Edit cells in locked columns/rows
• Set notifications and reminders for others
• Edit conditional formatting rules
• Create & manage web forms (licensed Admins only)
• Enable dependencies on a project sheet:
  • If all required columns (start, end, duration, predecessors) already exist in the sheet, both licensed and non-licensed Admins can enable dependencies.
  • If the sheet doesn't contain a required column, only a licensed Admin is able to enable dependencies as doing so will require Smartsheet to insert new columns.
• Edit dependency settings
• Publish the sheet

 

 

J. Craig Williams

PS #1

Strike through is not working

 

J. Craig Williams

PS #2

I tested with an Admin user and could add and delete columns.

 

I am a licensed user, but not in the account that "owns" the sheet.

 

So ... if the doc is true, then you are seeing what they say should happen.

If they doc is false, then I am.

 

Craig

Jeni Day

It must have changed somewhere along the road. I see the wording Licensed Admin now. I guess then only Owners can do the big changes - makes sense I suppose. Thanks for the help Craig - have a great day

 

J. Craig Williams

Jeni,

 

As I said, I have an Admin user in another account (non-licensed) but can modify things. Something may have changed.

 

Craig

Jason

From the help article on user types

 

"NOTE: If a non-licensed user is shared to a sheet as an Admin, they won't be able to create and manage web forms on the sheet or insert, rename, delete, hide/unhide, move or change the properties of columns. These features are only available to the sheet owner and licensed users with Admin sharing permissions." 

 

It sounds like your co-worker is an unlicensed admin. Support@smartsheet.com should be able to confirm. 

 

I don't relcall when the distinction between licensed and unlicensed admins was made but it did result in some accounts being grandfathered in under the old behavior (behaving like licenesed admins despite being unlicensed.) I suspect this is what J. Craig William's is seeing but I could be mistaken. 

 

Hope this helps a little!

JamesR

I believe the confusion is in the term Licenced Admin.

 

A licenced adminis is anybody that has a Smartsheet Licence whether they be in your organisation or not.  They must then be shared to the sheet or Wrkspace with Admin rights.

A non licenced user does not have a paid smartsheet licence.  If they are shared to a Sheet or workspace as Admin then they are unlicenced Admins.

 

That is my interpritation.

J. Craig Williams

My impression is that this is a recent change.

I have a non-licensed user in my account and I would swear that I have tested with it as Admin on sheets and never noticed that I could not make column changes.

 

Now there is a warning icon and the statement:

 

"You can access this feature when you upgrade your account"

 

I'm pretty sure I would have noticed that before, if I had seen it.

 

Craig

 

Richard Rymill SBP

The clues are in what Jason (an SS employee ) has said. The rules have changed over time and for some lucky "Grandfathers"they kept the old functionality longer that the newbies. 

You were not imagining it Craig. 

Yesterday we published our Table which JamesR compiled which will help us all with what you CAN and Cannot do at the close of 2016. 

https://app.smartsheet.com/b/publish?EQBCT=181e09e179c84d888adb37f7d3d12841

 

RichardR