为个人设定不同的工作日
有没有办法为个人设定不同的工作日?我知道可以通过项目设置功能定义工作日，但我想为一个人设置这个，只反映他们的兼职工作结构-这是可能的吗?
我们将感激地接受任何建议。
谢谢
答案
-
好吧谢谢
-
djpreece ✭
嗨
我的工程团队又问了这个问题，因为许多公司都有全球员工，我想这是一个常见的要求。我确实在2020年10月提交了增强请求。
我知道10,000英尺更适合资源管理，但不清楚它是否真的解决了这个问题(单个智能表上每个资源的假期安排)
有没有人有一个解决方案，不涉及多个表格/报告?
我的表有一个列，自动填充列与世界区域的每个资源，将是有用的，使用它来确认工作日与非工作日。(同样是同一页上的每个资源)
谢谢,
达雷尔
-
嘿,djpreece,
本来打算放弃的，但看到你的评论，决定再试一次。我把它修好了。
我们还有一个列表示“征税国家”。我最终使用NETWORKDAYS()函数来计算一个范围内的工作日数，然后将非工作日添加为第三个参数。第三个参数检查纳税国家，并应用另一个工作表中指定的一系列非工作日。
总结工作日，我只是在父行中做了sum (CHILDREN)，并将其复制到其他父行(同时关闭所有子行)，
希望这对你有帮助:)
类别
Yes, this looks to be unexpected, as your workflow should count as a \"sheet change\" and not a sharing invitation. <\/p>
Please submit your ticket to Support through the Support Portal <\/a>with the following information:<\/p>
- Screen capture of the second workflow build (as you have above, but including the message)<\/li>
- Identify the Workflow ID (Sheet > Automations > Manage Workflows > three dots in the top right > Workflow Properties)<\/li>
- Screen capture of the message received in Teams <\/li>
- Email address of the user that is receiving the notification<\/li>
- Screen capture of the user's Notification Preferences (as above)<\/li><\/ul>
Thank you,<\/p>
Genevieve<\/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":106775,"type":"question","name":"Smartsheet Automation to Remove a Single Value from Multi-Select Cell","excerpt":"I have multiple columns that denote tasks; Task 1, Task 2, Task 3, Task 4. Each of these tasks can have a cell value of; Completed, In Progress, and Not Started. I then have a multi-value dropdown column called Team that denotes what teams are necessary to complete a project. I have an automation in place to add the teams…","categoryID":321,"dateInserted":"2023-06-22T15:27:34+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T14:08:08+00:00","insertUserID":162639,"insertUser":{"userID":162639,"name":"SimonJackson123","url":"https:\/\/community.smartsheet.com\/profile\/SimonJackson123","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AjtpHwf2uTI!-5Pot6_mIzI!FUQIrqeEh_H","dateLastActive":"2023-06-23T14:43:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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:08:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":41,"score":null,"hot":3374983542,"url":"https:\/\/community.smartsheet.com\/discussion\/106775\/smartsheet-automation-to-remove-a-single-value-from-multi-select-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106775\/smartsheet-automation-to-remove-a-single-value-from-multi-select-cell","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":106775,"commentID":381969,"name":"Re: Smartsheet Automation to Remove a Single Value from Multi-Select Cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381969#Comment_381969","dateInserted":"2023-06-23T14:08:08+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:08:10+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-23T14:43:42+00:00","dateAnswered":"2023-06-23T13:48:58+00:00","acceptedAnswers":[{"commentID":381955,"body":"
Ah. Ok. I had a very different idea of the data structure, so the screenshot definitely helps. Try this:<\/p>
=IF([Task 1]@row <> \"Completed\", \"Team 1\" + CHAR(10), \"//www.santa-greenland.com/community/discussion/comment/\") + IF([Task 2]@row <> \"Completed\", \"Team 2\" + CHAR(10), \"//www.santa-greenland.com/community/discussion/comment/\") + IF([Task 3]@row <> \"Completed\", \"Team 3\" + CHAR(10), \"//www.santa-greenland.com/community/discussion/comment/\") + IF([Task 4]@row <> \"Completed\", \"Team 4\", \"//www.santa-greenland.com/community/discussion/comment/\")<\/p>
<\/p>The difference above as compared to typical IF statements is that usually they are nested, but in this case we want to \"add\" them together.<\/p>
<\/p>NOTE: CHAR(10) is the built in delimiter for multi-select columns and will allow each team to be treated as an individual selection within the cell in the event you need to filter or report on it.<\/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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":106762,"type":"question","name":"Data Shuttle Update Rows Workflow: Preventing Duplicate Updates","excerpt":"Hi all, I have a data shuttle update workflow that runs on a schedule updating rows in the target Smartsheet as they change in an excel source file stored in Box. I wanted to see if there was a way to somehow configure the data shuttle workflow so once a row has been updated, it can't be changed again. I tried doing this…","categoryID":321,"dateInserted":"2023-06-22T12:23:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T13:14:54+00:00","insertUserID":162120,"insertUser":{"userID":162120,"name":"cko","url":"https:\/\/community.smartsheet.com\/profile\/cko","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T12:17:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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:08:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":null,"hot":3374878131,"url":"https:\/\/community.smartsheet.com\/discussion\/106762\/data-shuttle-update-rows-workflow-preventing-duplicate-updates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106762\/data-shuttle-update-rows-workflow-preventing-duplicate-updates","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":106762,"commentID":381734,"name":"Re: Data Shuttle Update Rows Workflow: Preventing Duplicate Updates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381734#Comment_381734","dateInserted":"2023-06-22T13:14:54+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:08:10+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-22T17:00:56+00:00","dateAnswered":"2023-06-22T12:42:28+00:00","acceptedAnswers":[{"commentID":381723,"body":"
You would need to use a Move Row or Copy Row automation.<\/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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5401,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
