项目团队资源分配

Kiara_Ross_McCann
12/09/19编辑 公式函数

Hi

欧宝体育app官方888有人能分享他们的团队资源跟踪方式吗资源配置极大, 只允许我显示团队成员不多次执行任务此外,我需要这些信息执行报告支持我团队对项目分配过量的关切

谢谢

注释

  • 喜嘉拉

    欧宝体育app官方888不幸的是,无法分配多项资源执行单项任务常人要求Smartshet实现很长时间, 智能表似乎忽略所有解决此基本特征的要求。

  • AndréeStar
    AndréeStar ✭✭✭✭✭✭

    喜嘉拉

    这可能有帮助

    对 分派多人执行当前可用

    详情见附链接/截图

    https://help.smartsheet.com/articles/518335-assigning-people-to-a-task

    希望这能帮助你

    最优

    AndréeStar

    工作流咨询

    义工

    Hi所有

    很高兴宣布您现在可以快速易分配多项任务要做到这一点,请检查任何接触列中新的“单机多接触器”复选框列中的单元格允许最多增加20人

    单人一次分配任务时,您仍然可以任选不动

    向单元格添加多位联系人不仅对分配有用人间并面向其他假想,即您想将多利害相关方和行关联举例说,你可能希望这些人在行修改时收到通知,或你可能希望他们在报表和滤波中出现

    对某些项目,你似可添加2个联系列:一列主机主使用,二列增队成员使用

    欢迎你试一试 并告诉我们你的想法

    丹尼尔

    SmarthheET专家咨询方和伙伴

    AndréeStar工作流咨询/CEO@工作编程

    W:www.workbold.comE:[email protected]P:+46(0)-72-5109935

    自由联系我 帮助智能表整合 通用工作流建议

欧宝体育app官方888帮助文章资源

直接用Smartshe

查查 公式手册模板
Jelfner/a> SUMIF公式失序

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":"

angelapaj/a

3%为03尝试修改公式至++/p

IF(lippage@row/0/Green/

欢呼 ++/p

John<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&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":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式函数趋势