Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Sharing
Hi there SS community,
If I am running several sheets, when I share a sheet with someone... is that the only sheet that person sees?
Thanks,
Comments
-
Tim McCarthy ✭✭✭✭✭
Heidi,
One of the recent updates to smartsheet allows you to share individual sheets. Alternatively, you can share the entire workspace the sheet is part of. Check out the help videos and webinars for details.
-
Heidi Decker ✭✭✭✭✭✭
Thanks Tim, I've been watching all day trying to get up to speed on how things are done.
-
Tim McCarthy ✭✭✭✭✭
I understand. There is a lot of help there, but there are so many facets to learn. Learn the basics of what you need. This community is very helpful to fill in the details.
You wil find a great deal of similarity to Excel. But, also, several different functions and commands, some new functions, and some missing functions. I find some functions easier to implement in excel and then copy the resulting cells to my smartsheet.
For the sheet sharing, there are options to "Share Sheet" or "Share Workspace" which will share all sheets in the workspace.
-
Dave D ✭
When you share a sheet, you are only sharing that sheet UNLESS it is located in a workspace, then there is an option to share only the sheet or the workspace as well.
Workspace sharing:http://help.smartsheet.com/customer/en/portal/articles/522067-workspace-sharing
Sharing sheets:http://help.smartsheet.com/customer/en/portal/articles/520104-sharing-sheets
Categories
You need to remove the closing parenthesis from before the comma.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107143,"type":"question","name":"How can I get (on a separate metric sheet) the average SLA time within a given month?","excerpt":"I am trying to create a metric sheet to document how long response and acknowledgement times are taking per month for record keeping. I have a sheet that has an acknowledgement SLA column and a \"date of request\" (auto column for when the submission was created), and I'm looking to record the average for each month on a…","snippet":"I am trying to create a metric sheet to document how long response and acknowledgement times are taking per month for record keeping. I have a sheet that has an acknowledgement…","categoryID":322,"dateInserted":"2023-06-30T15:31:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T17:30:08+00:00","insertUserID":159225,"insertUser":{"userID":159225,"name":"laney_white","url":"https:\/\/community.smartsheet.com\/profile\/laney_white","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5FvXObtmaHw!CVFXQvc68Xo!anynrNoWe-v","dateLastActive":"2023-06-30T17:19:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-07-01T15:47:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3376287114,"url":"https:\/\/community.smartsheet.com\/discussion\/107143\/how-can-i-get-on-a-separate-metric-sheet-the-average-sla-time-within-a-given-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107143\/how-can-i-get-on-a-separate-metric-sheet-the-average-sla-time-within-a-given-month","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107143,"commentID":383369,"name":"Re: How can I get (on a separate metric sheet) the average SLA time within a given month?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383369#Comment_383369","dateInserted":"2023-06-30T17:30:08+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-07-01T15:47:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ZXS917R2FJKC\/master-sheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"master sheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T17:19:35+00:00","dateAnswered":"2023-06-30T15:50:27+00:00","acceptedAnswers":[{"commentID":383345,"body":"
If I understand correctly, this may help.<\/p>
=AVERAGEIF({date of request}, MONTH(@cell) = 2, {Ack SLA})<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
