为个人设定不同的工作日
有没有办法为个人设定不同的工作日?我知道可以通过项目设置功能定义工作日，但我想为一个人设置这个，只反映他们的兼职工作结构-这是可能的吗?
我们将感激地接受任何建议。
谢谢
答案
-
好吧谢谢
-
djpreece ✭
嗨
我的工程团队又问了这个问题，因为许多公司都有全球员工，我想这是一个常见的要求。我确实在2020年10月提交了增强请求。
我知道10,000英尺更适合资源管理，但不清楚它是否真的解决了这个问题(单个智能表上每个资源的假期安排)
有没有人有一个解决方案，不涉及多个表格/报告?
我的表有一个列，自动填充列与世界区域的每个资源，将是有用的，使用它来确认工作日与非工作日。(同样是同一页上的每个资源)
谢谢,
达雷尔
-
嘿,djpreece,
本来打算放弃的，但看到你的评论，决定再试一次。我把它修好了。
我们还有一个列表示“征税国家”。我最终使用NETWORKDAYS()函数来计算一个范围内的工作日数，然后将非工作日添加为第三个参数。第三个参数检查纳税国家，并应用另一个工作表中指定的一系列非工作日。
总结工作日，我只是在父行中做了sum (CHILDREN)，并将其复制到其他父行(同时关闭所有子行)，
希望这对你有帮助:)
类别
https:\/\/help.smartsheet.com\/articles\/2482082-configure-grouping-to-organize-results-in-report-builder<\/a><\/p>"},{"commentID":382036,"body":" That is only for grouping. If you are not grouping, there should be a small link if you scroll all the way to the bottom of the report to go to the next page.<\/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":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":106837,"type":"question","name":"All columns aren't showing up for Grouping in Reports","excerpt":"I'm pretty new to Smartsheet and can't figure out what I am doing wrong here. I am trying to Group by the \"PM\" column but it's not showing up in the list. It's formatted as a dropdown, but other columns that are appearing on the list are formatted the same way. What am I doing wrong? Thanks!","categoryID":321,"dateInserted":"2023-06-23T15:59:37+00:00","dateUpdated":"2023-06-23T16:10:12+00:00","dateLastComment":"2023-06-23T17:07:03+00:00","insertUserID":161580,"insertUser":{"userID":161580,"name":"LDP","title":"Sr. Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/LDP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T17:47:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161580,"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":"2023-06-23T17:40:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3375076600,"url":"https:\/\/community.smartsheet.com\/discussion\/106837\/all-columns-arent-showing-up-for-grouping-in-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106837\/all-columns-arent-showing-up-for-grouping-in-reports","format":"Rich","lastPost":{"discussionID":106837,"commentID":382035,"name":"Re: All columns aren't showing up for Grouping in Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382035#Comment_382035","dateInserted":"2023-06-23T17:07:03+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":"2023-06-23T17:40:35+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2EJA60U6S04F\/pm-column-issue.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"PM Column Issue.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T17:47:52+00:00","dateAnswered":"2023-06-23T17:07:03+00:00","acceptedAnswers":[{"commentID":382035,"body":" Is it set to allow for multiple selections? If so, reports cannot group by that. The only way to get it to work on a dropdown column is if it is set as a single select.<\/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":106777,"type":"question","name":"Struggling with Notification Preferences","excerpt":"I have a user with the following configuration: Two automations are defined: 1 - Trigger: When rows are changed. Alert Someone - Send to Specific People (contacts provided) 2 - Trigger: When rows are added or changed. Alert Someone- Send to Specific People (contacts provided) There is no problem with the notifications…","categoryID":321,"dateInserted":"2023-06-22T15:42:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T16:18:18+00:00","insertUserID":137494,"insertUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T16:17:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137494,"lastUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T16:17:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":45,"score":null,"hot":3374989855,"url":"https:\/\/community.smartsheet.com\/discussion\/106777\/struggling-with-notification-preferences","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106777\/struggling-with-notification-preferences","format":"Rich","lastPost":{"discussionID":106777,"commentID":382017,"name":"Re: Struggling with Notification Preferences","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382017#Comment_382017","dateInserted":"2023-06-23T16:18:18+00:00","insertUserID":137494,"insertUser":{"userID":137494,"name":"LWright","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LWright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nCDGV1TJ8PEJV.png","dateLastActive":"2023-06-23T16:17:39+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EC5H22Y159GM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-23T16:17:38+00:00","dateAnswered":"2023-06-23T15:46:21+00:00","acceptedAnswers":[{"commentID":382008,"body":"
