一个数据集，多个日历
我在Outlook日历上设置了一个表格。“PTO Detail”是主列，显示在日历上。我需要创建第二个日历与所有相同的日期与第二列“PTO详细团队”。最好的办法是什么?
所有的数据都是通过一个表单输入的，而且两个日历需要彼此100%一致。
我认为我需要将“PTO Detail Team”和日期列放到另一个工作表中，但我无法找到一种方法来自动、可靠地执行此操作，并使团队的详细信息成为日历所需要的主列。有人知道怎么做吗?
谢谢!
最佳答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
您可以使用与VLOOKUP或INDEX/MATCH结构相结合的交叉表公式来连接工作表，并且当您更新源工作表时，它将反映在目标工作表上。
为了逐行连接它们，您可以在Source工作表中使用自动编号列，并添加一个所谓的辅助列，以便在Destination工作表中手动添加行id。
这样行吗?
我希望这对你有帮助!
注意安全，祝你一周愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为“有见地”/“投票赞成”、“很棒”或“并且”作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
答案
-
她名叫Stara ✭✭✭✭✭✭
我希望你一切安好!
您可以使用与VLOOKUP或INDEX/MATCH结构相结合的交叉表公式来连接工作表，并且当您更新源工作表时，它将反映在目标工作表上。
为了逐行连接它们，您可以在Source工作表中使用自动编号列，并添加一个所谓的辅助列，以便在Destination工作表中手动添加行id。
这样行吗?
我希望这对你有帮助!
注意安全，祝你一周愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为“有见地”/“投票赞成”、“很棒”或“并且”作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
格洛丽亚H。 ✭✭嗨，安德烈，谢谢你的建议!这正是我一直想弄明白的，而且效果很好。我不知道有自动号码功能。
谢谢你! !
-
格洛丽亚H。 ✭✭
@Andree Stara随着对这个解决方案的进一步测试，我遇到了另一个问题，也许你可以帮助解决这个问题?
在表1中设置自动编号，并在表2中手动输入要匹配的编号，可以很好地设置索引匹配。当通过表单将新数据输入到表1中时，我遇到了问题。
我看到，当表单将新行添加到表的顶部时，表2上的索引匹配现在返回#NO match，除了新行之外的所有字段。
当我切换表单将新行添加到工作表底部时，工作表上的索引匹配对于所有现有数据都是准确的，但也会在新添加的行下面添加数百个额外的重复行。
当表1上的行被重新排序、过滤等时，表2似乎可以处理它，但当第1行被移出第一个位置时却不行。我有点理解这一点，但既然已经引入了副本，我就无法摆脱它们。
下面是我的索引匹配公式:
=INDEX({PTO Detail Team}， MATCH([Merge ID]@row， {Auto Number}))
安迪，你能给的洞察力将非常感激!!
类别
- Currently there is no sorting inside of a group. Please vote for that functionality in this Enhancement Request:<\/li><\/ol>\n \n https:\/\/community.smartsheet.com\/discussion\/104139\/group-management-sorting-contact-list-alphabetically\n <\/a>\n<\/div>\n
- To my knowledge this is not available. As a System Admin on Enterprise Plan, I can export the User List and sort\/filter that way but it would be nice to be able to do this inside of Smartsheet. From Plan & Billing\/User Management I can filter but it does not count.<\/li><\/ol>"}]}},"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":[{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106213,"type":"question","name":"Calendar App vs. Published Calendar View","excerpt":"Our support team is trying to publish a calendar and allow customers to click on the time slots for and enter their information to book a training. I have the sheet and the automation working well (formulas, automation, etc.). This all seems to work in Calendar view, but the saving and all gets a little weird, and the look…","categoryID":321,"dateInserted":"2023-06-08T16:33:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T12:10:26+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T12:08:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":103241,"lastUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T12:08:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":24,"score":null,"hot":3372557062,"url":"https:\/\/community.smartsheet.com\/discussion\/106213\/calendar-app-vs-published-calendar-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106213\/calendar-app-vs-published-calendar-view","format":"Rich","lastPost":{"discussionID":106213,"commentID":379798,"name":"Re: Calendar App vs. Published Calendar View","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379798#Comment_379798","dateInserted":"2023-06-09T12:10:26+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T12:08: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":"2023-06-09T12:10:37+00:00","dateAnswered":"2023-06-09T09:30:28+00:00","acceptedAnswers":[{"commentID":379774,"body":"
Hi @Autumn Beauchamp<\/a> <\/p>
I hope you're well and safe!<\/p>
Here's a possible workaround or workarounds <\/strong><\/p>
- You could automatically update the options left using the Premium app, Data Shuttle.<\/li>
- You could have a dashboard\/portal with the form on one side and the options left on the other side.<\/li><\/ul>
Would any of those options 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"},"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":106187,"type":"question","name":"Bridge Data Copy on checkbox = True help.","excerpt":"Good morning all! I've created a Bridge workflow that is supposed to be triggered off of a check box being checked (or flagged as true). This is running off of an expense form I've created. When I fill out the Expense form, the data I want copied is copied regardless of the check box being flagged or not. Essentially,…","categoryID":343,"dateInserted":"2023-06-08T11:52:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T12:17:25+00:00","insertUserID":146935,"insertUser":{"userID":146935,"name":"Coen","url":"https:\/\/community.smartsheet.com\/profile\/Coen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T12:24:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-09T12:56:50+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":29,"score":null,"hot":3372541193,"url":"https:\/\/community.smartsheet.com\/discussion\/106187\/bridge-data-copy-on-checkbox-true-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106187\/bridge-data-copy-on-checkbox-true-help","format":"Rich","lastPost":{"discussionID":106187,"commentID":379799,"name":"Re: Bridge Data Copy on checkbox = True help.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379799#Comment_379799","dateInserted":"2023-06-09T12:17:25+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-09T12:56:50+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":"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\/F9DD1QTUL789\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T12:08:56+00:00","dateAnswered":"2023-06-09T11:20:01+00:00","acceptedAnswers":[{"commentID":379789,"body":"
Hi @Coen<\/a> <\/p>
Your guess is exactly right! Since the checkboxes don't appear until there's content in the row, Bridge is likely reading the \"false\" value as a change<\/em> and triggering the workflow. The trigger is looking for any change, which could also include colour formatting in the cell. <\/p>
What I would personally do here is add a Get Row module<\/a> as the very first step of the workflow to get the row that triggered the workflow, using the Runtime Event to reference it:<\/p>
- To my knowledge this is not available. As a System Admin on Enterprise Plan, I can export the User List and sort\/filter that way but it would be nice to be able to do this inside of Smartsheet. From Plan & Billing\/User Management I can filter but it does not count.<\/li><\/ol>"}]}},"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":[{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106213,"type":"question","name":"Calendar App vs. Published Calendar View","excerpt":"Our support team is trying to publish a calendar and allow customers to click on the time slots for and enter their information to book a training. I have the sheet and the automation working well (formulas, automation, etc.). This all seems to work in Calendar view, but the saving and all gets a little weird, and the look…","categoryID":321,"dateInserted":"2023-06-08T16:33:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T12:10:26+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T12:08:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":103241,"lastUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T12:08:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":24,"score":null,"hot":3372557062,"url":"https:\/\/community.smartsheet.com\/discussion\/106213\/calendar-app-vs-published-calendar-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106213\/calendar-app-vs-published-calendar-view","format":"Rich","lastPost":{"discussionID":106213,"commentID":379798,"name":"Re: Calendar App vs. Published Calendar View","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379798#Comment_379798","dateInserted":"2023-06-09T12:10:26+00:00","insertUserID":103241,"insertUser":{"userID":103241,"name":"Autumn Beauchamp","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Beauchamp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T12:08: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":"2023-06-09T12:10:37+00:00","dateAnswered":"2023-06-09T09:30:28+00:00","acceptedAnswers":[{"commentID":379774,"body":"
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/DXNXPWHKYPF8\/screenshot-2023-06-09-at-12-15-24.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/OEVVEZF5JY4A\/screenshot-2023-06-09-at-12-15-32.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
