对基于更改行自动创建工作范围包有什么想法吗?
我有一个大型数据库，用户可以对其进行更改，然后将这些更改放入工作范围进行处理。我认为我不想使用突出显示更改功能，因为有时更改在处理之前可能会停留一两个月以上，而且我不想使用显示更改，因为我上次查看工作表选项，因为我经常查看工作表。
目前，我有它的设置复制行到另一个表时，任何变化。很好，效果很好。然而，在新的表格上，我看不出有什么变化。我真的需要它将它们复制到一个新的工作表，并突出显示在新工作表上的那一行所做的更改。
什么好主意吗?
答案
-
迈克电视 ✭✭✭✭✭✭
使用表单让用户提交更改请求(向另一个工作表)怎么样?然后你必须自己做出改变，但你知道要改变的是什么。
-
mccoy_FSI ✭✭嘿@Mike电视是的，我可以这样做，但是我想要更精简的工作流程。更改数据库条目时，将启动我的组的应用程序流程。然后，当批准时，数据库被标记为已批准，该数据在内部更新特定的文档。重要的是，它是一个闭环过程，所以我真的不想构建一个没有直接绑定到数据库的工作范围。
我想我会创建几个表来复制数据，并建立工作范围。因为我的数据库中只有几个主要项目发生了变化。所以，当x发生变化时，我将把它移到x变更表中，当Y发生变化时，我将把它移到Y变更表中，然后从这些变化中构建一个合并报告。不像我希望的那么干净，但我真的没有看到一种方法，除了在他们的主工作表上跟踪变化，捕捉行中发生的变化，而不是根据变化将行移动到不同的工作表。一个问题是，有时X和Y都改变了，那么我该把它发送到哪里呢?因此，最后，您提到的构建工作包的表单可能必须是我所做的。
-
寻找一个类似的解决方案来跟踪对项目组合所做的更改，这些更改都更新了进项表(基于模板集“项目管理办公室”)。将行复制到另一个工作表不起作用，因为有几个列通过单元格链接更新，这不会触发工作流自动化。
我想知道两个日期之间发生了什么变化。例如，5月1日和4月1日有什么不同。
谢谢!
类别
Through Smartsheet University there is a track called \"Core App Learning Path\". After completing the course, you earn the \"Core App Skills\" badge, and can claim 14 PDUs (for PMI education credits). The badge is different than the Core App Certification.<\/p>
Depending on your license and account level you might have to pay for Smartsheet University access. Your account rep or CSM (customer service manager) can help point you in the right direction.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":281,"urlcode":"Support","name":"Support"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":495,"urlcode":"smartsheet-certification","name":"Smartsheet Certification"}]},{"discussionID":105634,"type":"discussion","name":"Newish Community Member Intro","excerpt":"Howdy Folks! My name is Christian, and although I've been here a year, I never introduced myself. I'm a Controls and Automation Engineer that uses SmartSheet for project management and time tracking. My favorite SmartSheet pastimes include making long, complex, cross-sheet formulas, fully automating data entry, and lurking…","categoryID":346,"dateInserted":"2023-05-24T12:21:44+00:00","dateUpdated":"2023-05-24T12:22:38+00:00","dateLastComment":"2023-05-24T16:32:44+00:00","insertUserID":137683,"insertUser":{"userID":137683,"name":"Christian Graf","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20Graf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/RB11KNFTJXUR\/nVILSX5SOL3AU.jpg","dateLastActive":"2023-05-24T18:32:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":137683,"lastUserID":126614,"lastUser":{"userID":126614,"name":"Alison Clancy","title":"Community Engagement Manager II","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Clancy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nEFeH-a5APo!7Idee8avSzo!8w93-Gb3myE","dateLastActive":"2023-05-26T23:30:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":1,"hot":3369877768,"url":"https:\/\/community.smartsheet.com\/discussion\/105634\/newish-community-member-intro","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105634\/newish-community-member-intro","format":"Rich","lastPost":{"discussionID":105634,"commentID":377401,"name":"Re: Newish Community Member Intro","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377401#Comment_377401","dateInserted":"2023-05-24T16:32:44+00:00","insertUserID":126614,"insertUser":{"userID":126614,"name":"Alison Clancy","title":"Community Engagement Manager II","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Clancy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nEFeH-a5APo!7Idee8avSzo!8w93-Gb3myE","dateLastActive":"2023-05-26T23:30:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell"}],"groupID":null,"statusID":0,"attributes":{},"status":{"statusID":0,"name":"None","state":"open","recordType":"discussion","recordSubType":"discussion"},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","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":1}],"tags":[]}],"title":"Trending in Show & Tell","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
