链接回工作表
我们使用另一个平台来创建看板卡。工作表上是否有唯一的链接，我可以复制并粘贴到看板卡上，以便用户可以轻松地导航到正确的工作表?
评论
-
Maaik Meijerink ✭✭✭✭✭嗨,丹尼尔,
如果我是正确的，你的意思是唯一的url，这可以通过检查该工作表的属性找到(当工作表打开:使用下拉箭头旁边的工作表的名称)。
或者你指的是工作表中唯一的一行?
我们在4EF使用Zapier和Smartsheet API将Smartsheet(使用webforms制作的表格中的行)中的测试问题“传输”到Microsoft Visual Studio看板环境中。
但也许为了完全理解你的问题，也许你可以举个例子?
-
罗宾·舍伍德 员工嗨,丹尼尔,
我还对你们在看板中使用什么工具很感兴趣?卡片上的内容和纸上的有什么不同?我问这个问题的原因是，我们正在研究智能表的看板式视图。
谢谢你的发帖!
罗宾
类别
There are sometimes issues with data containing leading zeros. Try an @cell reference like so:<\/p>
=COUNTIFS({Range}, @cell =<\/strong> [Job Number]@row)<\/p> Do you have any job numbers anywhere that do not have a leading zero?<\/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":[]},{"discussionID":106824,"type":"question","name":"pulling distinct data to another sheet","excerpt":"I have a worksheet which I am working metrics on a separate worksheet. I have a list of courses on the main sheet and they can be duplicates. What I am trying to do is pulling those distinct courses onto another worksheet and I can use count how many times they are used for, but I need to pull that distinct courses from a…","categoryID":322,"dateInserted":"2023-06-23T13:21:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T13:54:22+00:00","insertUserID":160445,"insertUser":{"userID":160445,"name":"topazfae","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/topazfae","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbJ3U64IGvX8bmfaqFsly2Ax_danmhhYKsfmMgQsQ=s96-c","dateLastActive":"2023-06-23T17:00:58+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:40:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":20,"score":null,"hot":3375055535,"url":"https:\/\/community.smartsheet.com\/discussion\/106824\/pulling-distinct-data-to-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106824\/pulling-distinct-data-to-another-sheet","format":"Rich","lastPost":{"discussionID":106824,"commentID":381960,"name":"Re: pulling distinct data to another sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381960#Comment_381960","dateInserted":"2023-06-23T13:54:22+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:40:35+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-23T14:47:10+00:00","dateAnswered":"2023-06-23T13:54:22+00:00","acceptedAnswers":[{"commentID":381960,"body":" You would need a helper column on the metrics sheet (called \"Number\" in this example). You would manually enter the numbers 1 - whatever to cover the maximum number of possible unique classes. I also suggest a bit of a buffer just in case.<\/p> Then the formula to pull in the distinct list would be<\/p> =IFERROR(INDEX(DISTINCT({Course List}), Number@row), \"\")<\/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":[]}],"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":[]}">
<\/p>
<\/p>
