项目团队资源分配
注释
-
喜嘉拉
这可能有帮助
对 分派多人执行当前可用
详情见附链接/截图
https://help.smartsheet.com/articles/518335-assigning-people-to-a-task
希望这能帮助你
最优
AndréeStar
工作流咨询
义工
Hi所有
很高兴宣布您现在可以快速易分配多项任务要做到这一点,请检查任何接触列中新的“单机多接触器”复选框列中的单元格允许最多增加20人
单人一次分配任务时,您仍然可以任选不动
向单元格添加多位联系人不仅对分配有用人间并面向其他假想,即您想将多利害相关方和行关联举例说,你可能希望这些人在行修改时收到通知,或你可能希望他们在报表和滤波中出现
对某些项目,你似可添加2个联系列:一列主机主使用,二列增队成员使用
欢迎你试一试 并告诉我们你的想法
丹尼尔
AndréeStar工作流咨询/CEO@工作编程
W:www.workbold.comE:[email protected]P:+46(0)-72-5109935
自由联系我 帮助智能表整合 通用工作流建议
欧宝体育app官方888帮助文章资源
类别分类
sUMIF系统RANGE系统Criteria系统SUM_RANGEQ/p
试一下...
=SUMIF([PO Forecast Month]1:[PO Forecast Month]40, \"01-January\",[JO Volume]1:[JO Volume]40)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","description":"Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":115145,"type":"question","name":"Automation Question","excerpt":"I created a new sheet for information to be transferred too but when I go to setup the automation and select a sheet its empty any help?","snippet":"I created a new sheet for information to be transferred too but when I go to setup the automation and select a sheet its empty any help?","categoryID":322,"dateInserted":"2024-01-05T14:15:46+00:00","dateUpdated":null,"dateLastComment":"2024-01-05T14:25:47+00:00","insertUserID":170137,"insertUser":{"userID":170137,"name":"LeoCicio","url":"https:\/\/community.smartsheet.com\/profile\/LeoCicio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2024-01-05T14:22:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":170137,"lastUser":{"userID":170137,"name":"LeoCicio","url":"https:\/\/community.smartsheet.com\/profile\/LeoCicio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2024-01-05T14:22:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3408929493,"url":"https:\/\/community.smartsheet.com\/discussion\/115145\/automation-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/115145\/automation-question","format":"Rich","lastPost":{"discussionID":115145,"commentID":411995,"name":"Re: Automation Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/411995#Comment_411995","dateInserted":"2024-01-05T14:25:47+00:00","insertUserID":170137,"insertUser":{"userID":170137,"name":"LeoCicio","url":"https:\/\/community.smartsheet.com\/profile\/LeoCicio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2024-01-05T14:22:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EM61IMKG4YQG\/screenshot-2024-01-05-081255.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EM61IMKG4YQG\/screenshot-2024-01-05-081255.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EM61IMKG4YQG\/screenshot-2024-01-05-081255.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EM61IMKG4YQG\/screenshot-2024-01-05-081255.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EM61IMKG4YQG\/screenshot-2024-01-05-081255.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EM61IMKG4YQG\/screenshot-2024-01-05-081255.png"},"alt":"Screenshot 2024-01-05 081255.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2024-01-05T14:25:53+00:00","dateAnswered":"2024-01-05T14:25:47+00:00","acceptedAnswers":[{"commentID":411995,"body":"
found out myself you actually have to search so type in the sheet you want press enter and the sheet will come up<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","description":"Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":["discussion","question"]},"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":115139,"type":"question","name":"Percentage in a formula","excerpt":"Hi, Happy New Year!坚持我所想的简单公式 我希望你能帮助我RYG球有三个不同的阈值:3%以上-红色0-3%-黄下0-绿色我公式如下:坚持我所想的简单公式 我希望你能帮助我We have three different thresholds that I need to use to change the RYG…","categoryID":322,"dateInserted":"2024-01-05T10:32:12+00:00","dateUpdated":null,"dateLastComment":"2024-01-05T12:53:50+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2024-01-05T13:31:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":158375,"lastUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2024-01-05T13:31:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3408911162,"url":"https:\/\/community.smartsheet.com\/discussion\/115139\/percentage-in-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/115139\/percentage-in-a-formula","format":"Rich","lastPost":{"discussionID":115139,"commentID":411984,"name":"Re: Percentage in a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/411984#Comment_411984","dateInserted":"2024-01-05T12:53:50+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5BAYC7LUN4FS\/nVF87K3DDO2KL.jpg","dateLastActive":"2024-01-05T13:31:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2024-01-05T12:53:30+00:00","dateAnswered":"2024-01-05T12:31:56+00:00","acceptedAnswers":[{"commentID":411979,"body":"
公式函数趋势
- 苏密夫
需要JO卷列和下方我拥有至今, 但它不工作感谢帮助-谢谢sUMIF[JO卷4]1:[JO卷4]40,[PO预测月1:[PO预测月4
- 自动化问题
创建新表传递信息,但当我去搭建自动化并选择表空或帮助
- 百分比公式
新年快乐坚持我所想的简单公式 我希望你能帮助我3个不同的阈值需要我改变RYG球量 : 3%以上- 红色0-3%- 黄底0-绿色我公式如下: =IF(ISBLANK(Slippage@row)), ",IF(Slippage@row>0.3