Best Practice: Enterprise Sharing with SysAdmin?
My organization has an EPMO and as we roll out Smartsheet, the question has come up that if someone creates a new workspace they don't have to share it with the SysAdmin. Has anyone developed some standard in their organization that 'requires SysAdmin sharing' even as a viewer only?
If so, do you have any examples of the verbiage you use or the practice that you implemented? Our need for this is so that the Smartsheet workspaces do not get out of control.
Answers
-
Genevieve P. Employee AdminThere currently isn't a way to set sharing permissions across your entire account to ensure that all workspaces are shared with one contact.
However, at any time a System Admin can download aSheet Access Reportwhich will identify all the Smartsheet items associated with your organization, whether or not that Admin is shared. One of the columns in this report is Workspaces, so it would be easy to quickly identify if this Admin has access to all the Workspaces currently in the account, and if not, reach out to the Owner to ask to be shared.
See:More Actions in User Management
Cheers,
Genevieve
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/92037/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/92037/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCQ7U05Q4GNO\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/79GD9D2EWXCW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
