请求一个更新表单

Hi All,

Can I send the send column (cells) to the two persons to request the update at the same time?

I tried and it looks like only one person can update and the other person cannot update.

The picture below is the one I can actually type in and update.

image.png

Same thing for the other person was not able to do anything.

image.png

Thank you

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would have to send two separate update requests if they both need to be able to make an update.

    thinkspi.com

Hey Dennis,<\/p>

Are you referring to the Resource Management tool you find at the bottom of your workspace list?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-24 17:01:46","updateUser":{"userID":147345,"name":"Dennis M Wierzbicki","url":"https:\/\/community.smartsheet.com\/profile\/Dennis%20M%20Wierzbicki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xAHfcZhNJv8!!SOv7w7J1jdi","dateLastActive":"2022-08-24T18:34:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"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":[]},{"discussionID":94603,"type":"question","name":"Formula to change status based on sheet value","excerpt":"I'm trying to change a status (from a dropdown box in sheet summary, based on a date field. When a check box checked the status would change. Sheet Summary Field is \"Construction Status\", drop down list is: Not Started Permitting In Progress Permitted Inventory Slab Starts In Progress Slab Starts Inventory Vertical…","categoryID":321,"dateInserted":"2022-08-24T12:24:29+00:00","dateUpdated":null,"dateLastComment":"2022-08-24T15:00:19+00:00","insertUserID":125814,"insertUser":{"userID":125814,"name":"Jerry Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Alexander","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqleaeQavDo!XHld3zBOAjw!eGDZYT1_UCj","dateLastActive":"2022-08-24T15:07:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-25T01:59:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":33,"score":null,"hot":3322701288,"url":"https:\/\/community.smartsheet.com\/discussion\/94603\/formula-to-change-status-based-on-sheet-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94603\/formula-to-change-status-based-on-sheet-value","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":94603,"commentID":340921,"name":"Re: Formula to change status based on sheet value","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/340921#Comment_340921","dateInserted":"2022-08-24T15:00:19+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-25T01:59:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-24T13:48:31+00:00","dateAnswered":"2022-08-24T13:40:29+00:00","acceptedAnswers":[{"commentID":340902,"body":"

@Jerry Alexander<\/a> <\/p>

Try this and continue the pattern, so the last option is first.<\/p>

=IF(AND([Task Name]7 = \"Receive Permit\", Done7 = 1), \"Permitted Inventory\", IF(AND([Task Name]2 = \"Permit Prep (Docs to Runner)\", Started2 = 1), \"Permitting in Progress\", \"Not Started\"))<\/p>

Make sense?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-24 13:48:30","updateUser":{"userID":125814,"name":"Jerry Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Alexander","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqleaeQavDo!XHld3zBOAjw!eGDZYT1_UCj","dateLastActive":"2022-08-24T15:07:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":94592,"type":"question","name":"Automatically update Sub-Tasks when parent is changed","excerpt":"I am looking for a way to automatically update the completion status of sub tasks if the parent task is updated to completed. I have a project plan that varies based on how complicated the client is. If the client is large and complicated each task needs to be signed off individually, but if it is a small client, entire…","categoryID":321,"dateInserted":"2022-08-23T23:08:55+00:00","dateUpdated":null,"dateLastComment":"2022-08-24T13:19:22+00:00","insertUserID":151680,"insertUser":{"userID":151680,"name":"Zach Bru.","url":"https:\/\/community.smartsheet.com\/profile\/Zach%20Bru.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-24T14:31:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137711,"lastUser":{"userID":137711,"name":"SmartLew","title":"","url":"https:\/\/community.smartsheet.com\/profile\/SmartLew","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-24T17:45:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3322645097,"url":"https:\/\/community.smartsheet.com\/discussion\/94592\/automatically-update-sub-tasks-when-parent-is-changed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94592\/automatically-update-sub-tasks-when-parent-is-changed","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":94592,"commentID":340897,"name":"Re: Automatically update Sub-Tasks when parent is changed","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/340897#Comment_340897","dateInserted":"2022-08-24T13:19:22+00:00","insertUserID":137711,"insertUser":{"userID":137711,"name":"SmartLew","title":"","url":"https:\/\/community.smartsheet.com\/profile\/SmartLew","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-24T17:45:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/896NWYCRLURR\/smartsheet1.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SmartSheet1.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-24T14:31:52+00:00","dateAnswered":"2022-08-24T13:19:22+00:00","acceptedAnswers":[{"commentID":340897,"body":"

Hey Zach,<\/p>

How about a helper column which referenced the parent row on all sub-tasks?<\/p>

Add a column \"State Helper\" or similar. And in this have the formula =parent(state@row)<\/p>

This will automatically mirror the status of that parent row in the helper column. <\/p>

Then you can set an automation that says, when \"State Helper\" changes, update the cell Value in \"State\". <\/p>

You can use conditions to create different routes based on the status. You'll have to use a free text value to update the cell with, but that's ok as you will just mirror the state helper value.<\/p>

This way, you can also the subtasks manually also.<\/p>

In the scenrio that you individually complete subtasks, what would you be doing with your parent row? Would you leave this and mark as \"complete\" or similar when all subtasks were completed<\/p>

Let me know!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-24 14:31:52","updateUser":{"userID":151680,"name":"Zach Bru.","url":"https:\/\/community.smartsheet.com\/profile\/Zach%20Bru.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-24T14:31:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[{"tagID":334,"urlcode":"automations","name":"Automations"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">