Best Of

WorkApps Expansion of Number of Admins

My team recently learned that we can only have one admin for a WorkApp, which is causing some challenges and concerns. The main challenge is that the only time the WorkApp can be edited is when that single person is in office. We want to roll out wider use of WorkApps, but we need the person who works 8am-5pm and the person who works 5pm-10pm to both be able to make edits on the fly, and right now that isn't possible. We're toying with the idea of trying to hand off admin permissions at the end of our days right now, but that seems like it could easily pose other challenges. It doesn't seem like best practice for anyone to only have a single admin for anything, so it would be great if this can be addressed before we try to expand our use.

Carly Chaput

3 ·

Re: Can you have more than one Admin on WorkApps similar to Control Center?

@Ipshita Roles on WorkApps only allow members of those roles to view or not view pages. Having only one person be allowed to make changes to WorkApps is frightening to an org, meaning if this person is not in the office, then the changes just have to be done at a later time. Admins on Control Center have the same permissions as Owners, with just one or two limitations, but they can still take on the responsibility of managing the Program without having to bother the Owner. Similar to a sheet/report/dashboard.

Emilio Wright

1 ·

Re: New streamlined creation experience

It also removes the ability to move sheets currently in a workspace to an existing folder within "sheets".

Carson Penticuff

6 ·

Re: April Question of the Month - Join the conversation and receive a badge

This is my business Card holder, which is Glass and Engraves (I love personalized stuff). With the BC holder are my personal business cards, which I use for networking. And in the pre-Covid times, I left a card with each in-person interview. I have an MBA, and I know MANY of you also do, but I went to school late in life, AA completed 2009, BS completed 2011, and MBA completed 2019. It was a huge struggle, but I made it happen, and my career is better for the education, despite the long hours, hard work, and cost. The BC holder/and Business Cards remind me of that struggle to make myself better.

SherryFox

2 ·

Re: How to move certain columns only from one master sheet to another sheet

I wish we could. I also have a master sheet that's changing often - I would love an automation to copy specific columns to a new sheet for a row when a condition is met so that additional steps can be taken with that data. Maybe one day they'll update the automation feature.

khelwig

1 ·

Re: Formula for calculating the Monday before a date?

Try this one?

=IF([Ready]@row=1, (IF(Location@row = "Headquarters", IF(WEEKDAY([Start Date]@row) = 2, [Start Date]@row - 7, IF(WEEKDAY([Start Date]@row) = 3, [Start Date]@row - 1, IF(WEEKDAY([Start Date]@row) = 4, [Start Date]@row - 2, IF(WEEKDAY([Start Date]@row) = 5, [Start Date]@row - 3, IF(WEEKDAY([Start Date]@row) = 6, [Start Date]@row - 4, IF(WEEKDAY([Start Date]@row) = 7, [Start Date]@row - 5, [Start Date]@row - 6)))))), IF(WEEKDAY([Start Date]@row) = 1, [Start Date]@row - 2, IF(WEEKDAY([Start Date]@row) = 2, [Start Date]@row - 3, IF(WEEKDAY([Start Date]@row) = 3, [Start Date]@row - 4, IF(WEEKDAY([Start Date]@row) = 5, [Start Date]@row - 6, IF(WEEKDAY([Start Date]@row) = 4, [Start Date]@row - 5, IF(WEEKDAY([Start Date]@row) = 6, [Start Date]@row - 7, IF(WEEKDAY([Start Date]@row) = 7, [Start Date]@row - 1, "Error"))))))))),"Not Ready")

If this doesnt work, what error do you get?

NickStaffordPM

1 ·

Re: Why can't I move sheets to folders or workspaces if I am the owner of everything

Hi there,

I have the same issue with reports:

When I drag&drop a report into a (sub)folder, SmartSheet tells me, that the action is provibited due to missing access rights. However, I'm listed as the owner of the report as well as the containing folder and the receiving folder. When trying to use Devins approach, SmartSheet pops the same message at me.

Effectively I'm not able to move the report (or any item that is). I can delete it though.

Can you provide some clues? Thank you for your support.

Bernd Scheu

1 ·

Locking down an individual column to only allow one user to edit the column

We would like to lock down an individual column to only allow one user to edit the column. Unfortunately, we have several people updating the smartsheet and we would like to lock down the columns to the individuals that should be entering in the data. This will allow us to make that person responsible for their column.

AGoss

4 ·