欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论,你想找到(或创建)一个更最新的版本,请访问当前论坛。

推荐的主项目文件?

有没有推荐的方法来跟踪多个项目?显示多个项目的状态或项目的主控表或文档?我们已经做了一些基本的表单链接,但没有状态更新,而且相当手工。如果有一种方法可以在主项目文档中创建行项目,然后自动创建一个新的链接项目电子表格(从模板),那就太好了。

任何建议或想法都很感激!

乔LaPara

评论

这次讨论已经结束了。
OMG, I didn't click on the widget box, now I see the edit option. Thanks so much, this is going to be a game changer for me!<\/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":[]},{"discussionID":106584,"type":"question","name":"Index Match, how to recognize multiple values?","excerpt":"Hello, I have an issue with my index match formula. I want to locate the facility for a serial number. This works perfectly when there is only one value inside. However to reduce the amount of columns and options on the corresponding form, I changed it to one column that has multiple values. The formula is having…","categoryID":322,"dateInserted":"2023-06-18T21:21:35+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162488,"lastUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3374265958,"url":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","format":"Rich","lastPost":{"discussionID":106584,"commentID":381112,"name":"Re: Index Match, how to recognize multiple values?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381112#Comment_381112","dateInserted":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+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\/NDLYM9DFIQOI\/f1-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"f1.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T02:22:26+00:00","dateAnswered":"2023-06-19T02:12:19+00:00","acceptedAnswers":[{"commentID":381111,"body":"

Hey @Marcus Halvorson<\/a> <\/p>

Try this<\/p>

=IF(Available@row > 0, \"PES\", JOIN(INDEX(COLLECT(Facility:Facility, [Microscope: 1]:[Microscope: 1], HAS(@cell,\"6633112443\")), 1)))<\/p>

Will this 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":106545,"type":"question","name":"Automatically Delete Attachments when a condition is met?","excerpt":"Hello, I am looking for a way to automatically delete attachments on a row when the work is approved. Is this possible?","categoryID":322,"dateInserted":"2023-06-16T13:00:01+00:00","dateUpdated":"2023-06-16T13:00:52+00:00","dateLastComment":"2023-06-19T12:21:53+00:00","insertUserID":162459,"insertUser":{"userID":162459,"name":"Krys West","title":"Office Manager","url":"https:\/\/community.smartsheet.com\/profile\/Krys%20West","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T13:31:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162459,"lastUser":{"userID":162459,"name":"Krys West","title":"Office Manager","url":"https:\/\/community.smartsheet.com\/profile\/Krys%20West","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T13:31:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3374099514,"url":"https:\/\/community.smartsheet.com\/discussion\/106545\/automatically-delete-attachments-when-a-condition-is-met","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106545\/automatically-delete-attachments-when-a-condition-is-met","format":"Rich","lastPost":{"discussionID":106545,"commentID":381128,"name":"Re: Automatically Delete Attachments when a condition is met?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381128#Comment_381128","dateInserted":"2023-06-19T12:21:53+00:00","insertUserID":162459,"insertUser":{"userID":162459,"name":"Krys West","title":"Office Manager","url":"https:\/\/community.smartsheet.com\/profile\/Krys%20West","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T13:31:47+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T12:22:43+00:00","dateAnswered":"2023-06-16T18:43:16+00:00","acceptedAnswers":[{"commentID":381061,"body":"

Hi @Krys West<\/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>

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>

Please support the Community by marking the post(s)<\/em> <\/em><\/strong>that<\/em> <\/em><\/strong>helped or answered your question or solved your problem with <\/em>the accepted answer\/helpful, Insightful\/Vote Up\/Awesome<\/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"},"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":[]}],"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":[]}">

热门文章