我可以在工作区中的多个工作表中添加/更新行吗?

我想知道是否有可能在工作空间中的多个工作表中添加或更新行?

为了提供进一步的背景信息,我们目前通过在工作表中使用大型检查表来管理项目。我们经常会有公司流程变更,我所知道的更新每个项目流程的唯一方法是打开单独的表并添加/更改/删除单独的行。是否有某种方法,例如,有一个主模板表,一旦更新,更改将反映在工作区中的所有表上?

谢谢你!

l

答案

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    @Laurie R

    我希望你一切安好!

    这里有一个或多个可行的解决方案

    • 您可以设置它,这样您就有一个主表连接到每个项目表,并且您可以添加所谓的占位符行来稍后添加行,但是您必须使用过滤器/报告来不显示未使用的行。
    • 最好的选择是高级应用程序,控制中心,这是为这一点。这是一个选择吗?

    这些选择是否有用?

    我希望这对你有所帮助!

    注意安全,周末愉快!

    最好的

    她名叫Stara工作流顾问/ CEO @工作大胆

    我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为深刻的/投票或/和作为公认的答案.这将使其他人更容易找到解决方案或帮助回答!

    Smartsheet专家顾问和合作伙伴

    她名叫Stara工作流顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    关于Smartsheet、集成、一般工作流建议或其他方面的帮助,请随时与我联系。

  • 谢谢@Andree Stara

    我猜根据你的回答,我问的功能是不可能的?

    我不确定占位符行是否适合我,因为我不确定工作流中的额外步骤/s会使占位符行难以使用。

    我在想是不是我对Smartsheet要求太多了。

    谢谢你的帮助。

Hi @Benji241<\/a>. If you are able to trigger a workflow manually but it doesn't trigger automatically, check your trigger. In this case, your trigger is set to update the Status when a row is changed and the Status changes to \"Not Required.\" <\/p>

Instead, try this trigger:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

www.linkedin.com\/in\/juliefortney-pmp-smartsheetpartner-lssblackbelt<\/a><\/p>"},{"commentID":362100,"body":"

Hi @Benji241<\/a> - <\/p>

I think your workflow is contradicting itself - because your trigger and action are the same in this case. How do you update Status when you are asking the workflow to use Status as the basis? Instead I would suggest, create your workflow like this - <\/p>

When rows are added or changed -<\/p>

Any field<\/em> - changes<\/p>

Run workflow - when triggered<\/em><\/p>

Conditions - <\/p>

when Select the \"Category\" column <\/p>

is one of<\/em> \"Retaining Walls\"<\/p>

Action - <\/p>

Change cell value in <\/p>

Select column - Status - \"Not Required\"<\/p>

Hope this works! Let me know...<\/p>

Cheers! :)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-14 04:21:22","updateUser":{"userID":158252,"name":"Benji241","url":"https:\/\/community.smartsheet.com\/profile\/Benji241","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-14T04:33:25+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"}]},{"discussionID":101013,"type":"question","name":"Easiest way to \"If...Then\" when creating a new Resource Management project using Bridge","excerpt":"I'm working on my very first workflow to create a new project in Resource Management each time a new row is added to the master Smartsheet project sheet. So far, the mapping is pretty easy. However, I have a couple of fields where my end user has said, \"If the cell in Smartsheet has \"X\", put a \"Y\" in a related Resource…","categoryID":343,"dateInserted":"2023-02-10T22:46:19+00:00","dateUpdated":null,"dateLastComment":"2023-02-13T20:12:43+00:00","insertUserID":157936,"insertUser":{"userID":157936,"name":"ryanparmenter","url":"https:\/\/community.smartsheet.com\/profile\/ryanparmenter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-13T20:12:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":157936,"lastUser":{"userID":157936,"name":"ryanparmenter","url":"https:\/\/community.smartsheet.com\/profile\/ryanparmenter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-13T20:12:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3352389542,"url":"https:\/\/community.smartsheet.com\/discussion\/101013\/easiest-way-to-if-then-when-creating-a-new-resource-management-project-using-bridge","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101013\/easiest-way-to-if-then-when-creating-a-new-resource-management-project-using-bridge","format":"Rich","tagIDs":[369,468],"lastPost":{"discussionID":101013,"commentID":362061,"name":"Re: Easiest way to \"If...Then\" when creating a new Resource Management project using Bridge","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/362061#Comment_362061","dateInserted":"2023-02-13T20:12:43+00:00","insertUserID":157936,"insertUser":{"userID":157936,"name":"ryanparmenter","url":"https:\/\/community.smartsheet.com\/profile\/ryanparmenter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-13T20:12:02+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-13T20:12:17+00:00","dateAnswered":"2023-02-11T18:41:06+00:00","acceptedAnswers":[{"commentID":361833,"body":"

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

If possible, build a helper column in smartsheet and run the IF\/then from there. Then map that helper column instead of the original column in your Bridge\/RM integration. The community could help you with the IF\/THEN formula, if you need assistance.<\/p>

Would that work for you?<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-13 20:12:17","updateUser":{"userID":157936,"name":"ryanparmenter","url":"https:\/\/community.smartsheet.com\/profile\/ryanparmenter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-13T20:12:02+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":[{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]},{"discussionID":101000,"type":"question","name":"calculate cases for each for multi year metrics sheet","excerpt":"Hello, I combined the separate sheets i had for each which calculate the # of cases into a single one because it seems to easier to work with. For each individual condition, I calculate the # or cases per month in any particular year, however for the total # of cases for year the formula seems to calculate the total for…","categoryID":321,"dateInserted":"2023-02-10T19:48:28+00:00","dateUpdated":null,"dateLastComment":"2023-02-13T16:03:22+00:00","insertUserID":157776,"insertUser":{"userID":157776,"name":"OshaK","url":"https:\/\/community.smartsheet.com\/profile\/OshaK","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-13T16:03:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-13T17:22:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":37,"score":null,"hot":3352365710,"url":"https:\/\/community.smartsheet.com\/discussion\/101000\/calculate-cases-for-each-for-multi-year-metrics-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101000\/calculate-cases-for-each-for-multi-year-metrics-sheet","format":"Rich","lastPost":{"discussionID":101000,"commentID":361977,"name":"Re: calculate cases for each for multi year metrics sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/361977#Comment_361977","dateInserted":"2023-02-13T16:03:22+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-13T17:22:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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\/YRKM0U7WHD97\/screenshot-2023-02-10-at-11-40-54-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-02-10 at 11.40.54 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-13T16:03:25+00:00","dateAnswered":"2023-02-13T16:02:47+00:00","acceptedAnswers":[{"commentID":361976,"body":"

@Genevieve P.<\/a> this one works!<\/p>

=COUNTIFS({Event date}, IFERROR(MONTH(@cell), 0) = [Numerical Value]@row, {Event date}, IFERROR(YEAR(@cell), 0) = 2018)<\/p>


<\/p>

thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-02-13 16:03:25","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-02-13T17:22:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">