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.
Task completion updates
Hi, I have created a production schedule sheet which is viewed by the guys in the workshop. I'm trying to find the best way for them to give me updates on task completion. I dont want to give them editor access to the sheet because this them the ability to change the row details (resource). I have a %complete coulmn which ideally I would like for them to only update this coiumn.
I have thought about copying the whole sheet and linking cells back and forth but this would be very difficult to manage. Or to use a web form to update the column but I dont think this is possible.
一个ny thoughts?
Comments
-
Richard Rymill SBP ✭✭✭✭✭✭Kevin
Simple solution, give your workshop people Editor rights only, then Lock all the columns except the one(s) you want them to edit. Hope that helps? Richardr
-
Thanks Richard, I have just been trying that however editors can delete rows
If I lock the rows they then cant edit the cells either.
Its almost as if I need to lock the whole sheet apart from one column. -
Richard Rymill SBP ✭✭✭✭✭✭
I would do exactly that Kevin and also issue a protocol for collaborators to understand what is.... and ISNT expected of them when working with you. Most people appreciate that clarity especially when there are so many benefits to a range of collaborators with your work... ie dont let the team down! Good Luck. Richardr
-
Its not really how I want to do it as it puts my sheet at risk of people deleting rows etc.
Perhaps Im using it a little different from the way it is intended. I personally like the idea of individual cells being editable/lockable. Or even using a web form to update existing rows.
It think if i was clever I could embed some code into our website to modify cells... But it should be simpler.谢谢你的建议。
Kevin
Categories
In your sheet, create a third section that adds the results of the first two. It would have the same rows, but the formula for each row would add the cells of section 1 + section 2.<\/p>
Add a helper column called ShowInReport as a Check Box and check all the rows in the third section. <\/p>
Create a report and tell it to show you only Section 3 (where the ShowInReport is true.<\/p>
I hope that makes sense.<\/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":108888,"type":"question","name":"Is it possible to URL-Query an embedded form?","excerpt":"I am wondering if it is possible to prefill an embedded form on a dashboard by referencing the form in the dashboard URL?","snippet":"I am wondering if it is possible to prefill an embedded form on a dashboard by referencing the form in the dashboard URL?","categoryID":321,"dateInserted":"2023-08-13T01:16:42+00:00","dateUpdated":null,"dateLastComment":"2023-08-13T11:02:58+00:00","insertUserID":161632,"insertUser":{"userID":161632,"name":"SteyJ","title":"Jacob Stey","url":"https:\/\/community.smartsheet.com\/profile\/SteyJ","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5Zjq-V_rc4o!zmkrczO71bo!6kwXWfi9FUH","dateLastActive":"2023-08-13T22:08:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-13T23:49:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"score":null,"hot":3383814580,"url":"https:\/\/community.smartsheet.com\/discussion\/108888\/is-it-possible-to-url-query-an-embedded-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108888\/is-it-possible-to-url-query-an-embedded-form","format":"Rich","tagIDs":[204,254,292,530],"lastPost":{"discussionID":108888,"commentID":390381,"name":"Re: Is it possible to URL-Query an embedded form?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390381#Comment_390381","dateInserted":"2023-08-13T11:02:58+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-13T23:49:27+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-13T15:45:48+00:00","dateAnswered":"2023-08-13T11:02:58+00:00","acceptedAnswers":[{"commentID":390381,"body":"
