I believe this has now been answered on your other post?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 18:08:39","updateUser":{"userID":153468,"name":"BWheel","url":"https:\/\/community.smartsheet.com\/profile\/BWheel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T18:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":97642,"type":"question","name":"Adding Smartsheets that have been shared to me to a folder","excerpt":"Hi, I receive a lot of shared smartsheet plans from colleagues and I would like to create links to these plans in a folder structure that I have created. Essentially, I'm trying to create shortcuts to each shared smartsheet, in the folder but cannot see a way to do this. Is this possible? Many thanks in advance Andrew","categoryID":321,"dateInserted":"2022-11-11T10:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-11-11T13:44:43+00:00","insertUserID":137901,"insertUser":{"userID":137901,"name":"Andrew Foster","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Foster","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T13:46:13+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-11-13T15:27:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":20,"score":null,"hot":3336336883,"url":"https:\/\/community.smartsheet.com\/discussion\/97642\/adding-smartsheets-that-have-been-shared-to-me-to-a-folder","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97642\/adding-smartsheets-that-have-been-shared-to-me-to-a-folder","format":"Rich","lastPost":{"discussionID":97642,"commentID":350837,"name":"Re: Adding Smartsheets that have been shared to me to a folder","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350837#Comment_350837","dateInserted":"2022-11-11T13:44:43+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-11-13T15:27:07+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-11-11T11:26:04+00:00","dateAnswered":"2022-11-11T10:23:53+00:00","acceptedAnswers":[{"commentID":350833,"body":"
Hi @Andrew Foster<\/a> <\/p>
I hope you're well and safe!<\/p>
Unfortunately, it's not possible now, but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p>
Here's a possible workaround or workarounds <\/strong><\/p>
- I'd recommend adding them on a sheet or\/and a Dashboard\/Portal instead.<\/li><\/ul>
Would that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 11:26:04","updateUser":{"userID":137901,"name":"Andrew Foster","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Foster","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T13:46:13+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":97633,"type":"question","name":"How to change status for one product type when a new item is added with the new status.","excerpt":"Hello, I am tracking project submissions in a smartsheet list. Each project may has more than one phase, so the project steps appear in separate lines. When someone submits the final step, I would like the status column next to each step of the project to show \"complete\" (or checked). I think this would be a workflow…","categoryID":343,"dateInserted":"2022-11-10T21:31:55+00:00","dateUpdated":"2022-11-11T08:04:39+00:00","dateLastComment":"2022-11-11T19:59:41+00:00","insertUserID":153468,"insertUser":{"userID":153468,"name":"BWheel","url":"https:\/\/community.smartsheet.com\/profile\/BWheel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T18:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-11-13T15:17:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":42,"score":null,"hot":3336316296,"url":"https:\/\/community.smartsheet.com\/discussion\/97633\/how-to-change-status-for-one-product-type-when-a-new-item-is-added-with-the-new-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97633\/how-to-change-status-for-one-product-type-when-a-new-item-is-added-with-the-new-status","format":"Rich","lastPost":{"discussionID":97633,"commentID":350902,"name":"Re: How to change status for one product type when a new item is added with the new status.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350902#Comment_350902","dateInserted":"2022-11-11T19:59:41+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-11-13T15:17:40+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NLKRL7GUO1C5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-11T17:35:28+00:00","dateAnswered":"2022-11-11T17:21:17+00:00","acceptedAnswers":[{"commentID":350882,"body":"
You would use a column formula such as this (in the checkbox column):<\/p>
=IF(COUNTIFS([Project ID]:[Project ID], @cell = [Project ID]@row, [Is this completed?]:[Is this completed?], @cell = \"Yes\") > 0, 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 17:35:28","updateUser":{"userID":153468,"name":"BWheel","url":"https:\/\/community.smartsheet.com\/profile\/BWheel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T18:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
她名叫Stara ✭✭✭✭✭✭
