跳转到仪表板中的位置

CBlass
CBlass ✭✭✭
在内容基本知识

是否有可能有一个链接跳转到一个小部件从仪表板内?我不认为这是目前的功能，但我想在提交想法之前检查一下。我的用例是一个目录/议程表，这样您就可以知道仪表板顶部包含的所有高级项目，并可以跳转到下面更详细的报告。

标签:
· 在Facebook上分享 在Twitter上分享

最佳答案

答案

类别

Ok. Instead of nesting your IFs together, you want to \"add\" then together and use a HAS function.<\/p>

=IF(HAS([Flight Profile]@row, \"Normal Call - In Country\"), 1, 0) + IF(HAS([Flight Profile]@row, \"Normal Call - Out of Country\"), 3, 0) + ..........................................<\/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":106654,"type":"question","name":"I cannot get the jira connector to work","excerpt":"I have a business account. I am an Admin in Jira. There is nothing telling me how to connect. When I click on connect it tells me to contact SmartSheet. I had an account manager. Cant find his name. Can't seem to put in a support ticket either.","categoryID":343,"dateInserted":"2023-06-20T18:25:35+00:00","dateUpdated":"2023-06-21T11:24:59+00:00","dateLastComment":"2023-06-21T12:52:23+00:00","insertUserID":159164,"insertUser":{"userID":159164,"name":"clawson","url":"https:\/\/community.smartsheet.com\/profile\/clawson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8k6WqAcj3CUkjC0jOTaQM0V6AiPZO2dYG7Ihh=s96-c","dateLastActive":"2023-06-21T12:52:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-21T18:51:38+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":null,"hot":3374638078,"url":"https:\/\/community.smartsheet.com\/discussion\/106654\/i-cannot-get-the-jira-connector-to-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106654\/i-cannot-get-the-jira-connector-to-work","format":"Rich","lastPost":{"discussionID":106654,"commentID":381467,"name":"Re: I cannot get the jira connector to work","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381467#Comment_381467","dateInserted":"2023-06-21T12:52:23+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-21T18:51:38+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T12:54:58+00:00","dateAnswered":"2023-06-21T12:52:23+00:00","acceptedAnswers":[{"commentID":381467,"body":"

Hi @clawson<\/a> <\/p>

The Jira Connector would need to be purchased in addition to your Smartsheet plan. If your plan doesn't include this connector, you can contact the Sales team from this page. <\/a><\/p>

Here's more information: Smartsheet for Jira Connector: Overview<\/a><\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":106634,"type":"question","name":"Formula to set the Task Health.","excerpt":"Hi Good Morning, I have a question on this formula. Can you tell me what I did wrong please? Thanks for your great help.","categoryID":321,"dateInserted":"2023-06-20T14:28:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T14:04:40+00:00","insertUserID":162441,"insertUser":{"userID":162441,"name":"AAL","title":"Automation - Record a Date","url":"https:\/\/community.smartsheet.com\/profile\/AAL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T15:13:51+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-21T18:36:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":72,"score":null,"hot":3374634784,"url":"https:\/\/community.smartsheet.com\/discussion\/106634\/formula-to-set-the-task-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106634\/formula-to-set-the-task-health","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106634,"commentID":381484,"name":"Re: Formula to set the Task Health.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381484#Comment_381484","dateInserted":"2023-06-21T14:04:40+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-21T18:36:57+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\/Y9UHM44PUCBT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T18:05:21+00:00","dateAnswered":"2023-06-20T17:22:23+00:00","acceptedAnswers":[{"commentID":381355,"body":"

Happy to help. 👍️<\/span><\/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":254,"urlcode":"Formulas","name":"Formulas"}]}],"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":5391,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 和帮助

    我是一个有智能手机的新手，还在学习。我正在构建一个风险评估工具，最终用户的表单有复选框。每个框都有一个基于风险的特定值。所以从一个盒子到所有的盒子都可以被选中。我需要勾选所有箱子的总数。这就是我被卡住的地方:=IF([航班配置文件]@row…

  • 我无法使jira连接器工作

    我有一个商业账户。我是Jira的一名行政人员。没有任何东西告诉我如何连接。当我点击连接时，它告诉我联系SmartSheet。我有一个客户经理。找不到他的名字。好像也不能给我一张支持票。

  • 公式设置任务运行状况。

    你好，早上好，我有一个关于这个公式的问题。你能告诉我我做错了什么吗?谢谢你的帮助。