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.

Allowing users to only add a row to a sheet and view only those rows

NA
NA ✭
edited 12/09/19 inArchived 2015 Posts

New to Smartsheet and hoping this may be a simple question....

I want to be able to create a sheet that anyone in my company can access, but with the following permission groups:

1. Admin (full access)

2.Edit rights (limited to specific users, columns and rows)

3. View rights (limited to specific users, columns and rows)

4.Ability to add a row to the sheet, but not view any other content other than rows they started. This user should also be able to share that row with others that they choose.

I believe 1, 2 and 3 are in place with SmartSheet immediately. Can someone help me see if there is a way to do number 4?

Thanks!

Tags:
· Share on Facebook Share on Twitter

Comments

  • Bobby Andres
    Bobby Andres ✭

    1, 2, and 3 are possible right now with normal sharing permissions.

    4 is not. Smartsheet does not have that granular of sharing levels at the moment. I think there was some talk about allowing users to share only part of sheets in the future.

    You could always sendupdate requestswhich will enable you to send a single row or group of rows to anyone via email. The recipient can view and edit the sent rows but wont have access to any other part of the sheet. This is a one time view/edit though. You can set these to send on a recurring basis.

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

Hey @CFT<\/a> <\/p>

Try this<\/p>

IF([Location ID]@row<>\"//www.santa-greenland.com/community/discussion/1685/\", IFERROR(INDEX({Training Requests \/ Tracking Range 3}, MATCH([Location ID]@row, {Training Requests \/ Tracking Range 1}, 0)), INDEX({Completed Training Requests \/ Tracking Range 3}, MATCH([Location ID]@row, {Completed Training Requests \/ Tracking Range 2}, 0))))<\/p>

Does this do work for you?<\/p>

Kelly<\/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":[]},{"discussionID":108478,"type":"question","name":"Analyse three columns content and produce a representation of request priority","excerpt":"Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a \"date created\" column, and a column that shows the user\/form…","snippet":"Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service…","categoryID":322,"dateInserted":"2023-08-03T15:28:13+00:00","dateUpdated":null,"dateLastComment":"2023-08-04T05:59:30+00:00","insertUserID":154724,"insertUser":{"userID":154724,"name":"JohnaP","url":"https:\/\/community.smartsheet.com\/profile\/JohnaP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T05:58:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154724,"lastUser":{"userID":154724,"name":"JohnaP","url":"https:\/\/community.smartsheet.com\/profile\/JohnaP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T05:58:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3382206463,"url":"https:\/\/community.smartsheet.com\/discussion\/108478\/analyse-three-columns-content-and-produce-a-representation-of-request-priority","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108478\/analyse-three-columns-content-and-produce-a-representation-of-request-priority","format":"Rich","tagIDs":[204,254,265,292,533],"lastPost":{"discussionID":108478,"commentID":388843,"name":"Re: Analyse three columns content and produce a representation of request priority","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388843#Comment_388843","dateInserted":"2023-08-04T05:59:30+00:00","insertUserID":154724,"insertUser":{"userID":154724,"name":"JohnaP","url":"https:\/\/community.smartsheet.com\/profile\/JohnaP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T05:58:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-04T05:59:00+00:00","dateAnswered":"2023-08-03T15:58:41+00:00","acceptedAnswers":[{"commentID":388734,"body":"

@JohnaP<\/a> <\/p>

I have something similar to track service requests. I would suggest you create a sheet with the following columns.<\/p>

Department, Red, Yellow, Green, Blue.<\/p>

In the Department column, manually put in the 15 department names, in the other columns, use a countif formula to get the total number of each color, you can then bring those into Metrics and Graphs on your dashboard.<\/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":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":533,"urlcode":"web-content-widget","name":"web content widget"}]},{"discussionID":108505,"type":"question","name":"How to Sum if field contains the same text","excerpt":"Hello, Could you please assist me in developing a formula that will display a grand total if a certain criteria is met? What I'm looking for is highlighted in the table's Sum field. Thank you","snippet":"Hello, Could you please assist me in developing a formula that will display a grand total if a certain criteria is met? What I'm looking for is highlighted in the table's Sum…","categoryID":321,"dateInserted":"2023-08-03T20:39:56+00:00","dateUpdated":null,"dateLastComment":"2023-08-03T23:12:52+00:00","insertUserID":158918,"insertUser":{"userID":158918,"name":"Jen K.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20K.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T08:10:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":158918,"lastUser":{"userID":158918,"name":"Jen K.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20K.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T08:10:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3382200768,"url":"https:\/\/community.smartsheet.com\/discussion\/108505\/how-to-sum-if-field-contains-the-same-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108505\/how-to-sum-if-field-contains-the-same-text","format":"Rich","lastPost":{"discussionID":108505,"commentID":388824,"name":"Re: How to Sum if field contains the same text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388824#Comment_388824","dateInserted":"2023-08-03T23:12:52+00:00","insertUserID":158918,"insertUser":{"userID":158918,"name":"Jen K.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20K.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T08:10:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T23:12:14+00:00","dateAnswered":"2023-08-03T21:59:27+00:00","acceptedAnswers":[{"commentID":388809,"body":"

Are you attempting to replicate your screenshot? If so, using this as a column formula in your SUM column will do so.<\/p>

=SUMIF([Color]:[Color], @cell = [Color]@row, [# of Hours]:[# of Hours])<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[]}],"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":[]}">

Trending Posts

  • Index Match Question

    I am trying to auto populate training status from an active Training Tracking sheet and a Completed Training Tracking sheet into a 3rd sheet (Field Activity Tracker) using Index Match. Individually, my formulas work great unless the {Location ID}@row column I am Indexing is blank (Still works, just matching a blank column…

  • Analyse three columns content and produce a representation of request priority

    Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a "date created" column, and a column that shows the user/form…

  • How to Sum if field contains the same text

    Hello, Could you please assist me in developing a formula that will display a grand total if a certain criteria is met? What I'm looking for is highlighted in the table's Sum field. Thank you