欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论,你想找到(或创建)一个更最新的版本,请访问当前论坛。

在公式中使用“当前用户”

希望我没有错过一些明显的东西,但是有可能在公式中使用“当前用户”吗?

我想在一个任务列表中的单元格计算分配给当前用户的所有任务与2个状态选项中的任何一个。我可以编写公式来选择一个特定的名称,但是我想在Sight中使用这个数字来帮助我的团队管理他们的工作量。目前的公式如下-

受让人:受让人,“John Smith”,身份:身份,OR(@cell= " 1。新项目”,@cell= " 2。在进步”))

我希望用当前用户的名称替换实际名称。

评论

  • 没有办法在公式中使用“当前用户”作为条件,必须键入特定的名称(如公式示例所示)。当前用户标准在Sight(在报表小部件中)上的作用方式是,当查看Sight时,当前用户将查看总是成为第一个添加报告小部件的人。

    即使我们要添加这个公式参数,我也希望这个行为保持不变。

    请随时通过社区网站右侧快速链接下的产品增强请求表单直接向我们的产品团队提交您的想法和用例。ob欧宝娱乐app手机下载

  • Hirsty2000
    编辑05/30/17

    这是一个耻辱,也是我在组织内继续使用产品的主要障碍。ob欧宝娱乐app手机下载

  • mmuir
    mmuir ✭✭

    令人遗憾的是,小部件反映的是添加小部件的用户,而不是登录的用户。我很想能够显示特定于登录用户的项目列表。让一个小部件在仪表板上反映我的项目,而不是关注用户登录,这是一种误导。

    但是,我仍然认为我可以通过报告把一些东西放在一起,仍然允许他们从报告中审查他们所有的项目。

这次讨论已经结束了。
@WillH<\/a> This is not possible using Smartsheet forms. You can:<\/p>
  1. Send an update request for a specific row, which is form-like in appearance <\/li>
  2. Use another solution such as Appsheet (it is really easy to do this in Appsheet by the way). The video below shows selecting an existing row based on a value in the row encoded in an NFC tag. Much more than you are looking to do, but my point is that you can use Appsheet to select the row you want to edit from a dropdown :)<\/li><\/ol>
    \n \n https:\/\/youtu.be\/bmxQhhMONFY\n <\/a>\n<\/div>


    <\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":106434,"type":"question","name":"Sheet with Single Row needs formula across the row?","excerpt":"I have a sheet of indicators that pulls info from another sheet to process the correct indicator. I now need to set an overall status in the same row from the other indicators Here is the sheet and it will always look like this just one row So the second column Program needs to have a formula that looks at all the other…","categoryID":322,"dateInserted":"2023-06-14T16:31:32+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T17:02:37+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T18:28:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162256,"lastUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T18:28:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":36,"score":null,"hot":3373526049,"url":"https:\/\/community.smartsheet.com\/discussion\/106434\/sheet-with-single-row-needs-formula-across-the-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106434\/sheet-with-single-row-needs-formula-across-the-row","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106434,"commentID":380560,"name":"Re: Sheet with Single Row needs formula across the row?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380560#Comment_380560","dateInserted":"2023-06-14T17:02:37+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T18:28:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"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\/ADQKQAFJZCL9\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T16:52:48+00:00","dateAnswered":"2023-06-14T16:46:53+00:00","acceptedAnswers":[{"commentID":380549,"body":"

    Try a nested IF formula.<\/p>

    =IF(Schedule@row = \"Red\", \"Red\", IF(Scope@row = \"Red\", \"Red\", IF(Budget@row = \"Red\", \"Red\", IF(Infrastructure@row = \"Red\", \"Red\", IF(Data@row = \"Red\", \"Red\", IF(Resources@row = \"Red\", \"Red\", IF(Schedule@row = \"Yellow\", \"Yellow\", IF(Scope@row = \"Yellow\", \"Yellow\", IF(Budget@row = \"Yellow\", \"Yellow\", IF(Infrastructure@row = \"Yellow\", \"Yellow\", IF(Data@row = \"Yellow\", \"Yellow\", IF(Resources@row = \"Yellow\", \"Yellow\", \"Green\"))))))))))))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106402,"type":"question","name":"Formula trouble: Average score for specific word in multi-select column","excerpt":"I have scrubbed the community board for this answer, but was unable to find the formula I needed. Therefore I am sending out an SOS. :) On the master sheet, I am calculating scores and an overall total average. Example formula: =AVERAGEIF([NE: Value]:[NE: Value], <>\"//www.santa-greenland.com/community/discussion/9661/\") -- This is working On my metrics sheet, I would like…","categoryID":322,"dateInserted":"2023-06-13T21:49:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T18:03:44+00:00","insertUserID":158092,"insertUser":{"userID":158092,"name":"MeganJF","url":"https:\/\/community.smartsheet.com\/profile\/MeganJF","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DgFow9e-1vo!YfMmmJOUTjo!UDpVBcB6ikY","dateLastActive":"2023-06-14T17:57:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":158092,"lastUser":{"userID":158092,"name":"MeganJF","url":"https:\/\/community.smartsheet.com\/profile\/MeganJF","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DgFow9e-1vo!YfMmmJOUTjo!UDpVBcB6ikY","dateLastActive":"2023-06-14T17:57:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3373460615,"url":"https:\/\/community.smartsheet.com\/discussion\/106402\/formula-trouble-average-score-for-specific-word-in-multi-select-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106402\/formula-trouble-average-score-for-specific-word-in-multi-select-column","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106402,"commentID":380600,"name":"Re: Formula trouble: Average score for specific word in multi-select column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380600#Comment_380600","dateInserted":"2023-06-14T18:03:44+00:00","insertUserID":158092,"insertUser":{"userID":158092,"name":"MeganJF","url":"https:\/\/community.smartsheet.com\/profile\/MeganJF","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DgFow9e-1vo!YfMmmJOUTjo!UDpVBcB6ikY","dateLastActive":"2023-06-14T17:57:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T18:16:45+00:00","dateAnswered":"2023-06-14T16:48:45+00:00","acceptedAnswers":[{"commentID":380551,"body":"

    Hey @MeganJF<\/a> <\/p>

    I agree with @Hollie Green<\/a>! You can use an AVG(COLLECT to average a column based on multiple conditions. <\/p>

    An AVG(COLLECT works like this:<\/p>

    =AVG(COLLECT({Range to Avg}, {First Criteria Column}, \"Criteria 1\", {Second Criteria Column}, \"Criteria 2\"))<\/p>

    So in your case, try something like this:<\/p>

    =AVG(COLLECT({Range NE:Value}, {Range NE:Value}, <> \"//www.santa-greenland.com/community/discussion/9661/\", {Range BU}, [item2]@row))<\/p>


    <\/p>

    See: Average with multiple conditions<\/a><\/p>

    Cheers,<\/p>

    Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

    热门文章