Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Linking Back to a Sheet

Daniel Minzner
Daniel Minzner ✭
edited 12/09/19 inArchived 2015 Posts

We use another platform to create Kanban cards. Is there a unique link on a sheet that is unique that I can copy and paste onto my Kanban card so that the user can easily navigate to the correct sheet?

Tags:
· Share on Facebook Share on Twitter

Comments

  • Maaik Meijerink
    Maaik Meijerink ✭✭✭✭✭

    Hi Daniel,

    If I am correct you mean the unique url, which can be found by checking the properties for that sheet (When the sheet is opened: use the dropdown-arrow next to the name of the sheet).

    Or do you mean a unique row in a sheet ?

    We at 4EF use Zapier and the Smartsheet API to 'transport' test issues made within Smartsheet (rows in a sheet made with webforms) to a Microsoft Visual Studio Kanban environment.

    But perhaps to fully understand your question, perhaps you can give an example ?

    Naamloos.png

    · Share on Facebook Share on Twitter
  • Robin Sherwood
    Robin Sherwood Employee

    Hey Daniel,

    I'm also interested in what tool you are using for Kanban? How is the content different in your cards than on your sheet? The reason I'm asking is that we are working on o a Kanban style view for smartsheet.

    Thanks for posting!

    Robin

    · Share on Facebook Share on Twitter
  • Kennedy Stomps
    Kennedy Stomps Employee

    Hi Daniel-- I just wanted to update you that we have good news: Card View, our new Kanban-style sheet view, is here! You can now access the Card View in any sheet that contains at least one dropdown column. More information on the new view is available inthis Announcement.

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

\n \n https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula\n <\/a>\n<\/div>\n

Hi, <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=IF([Date Reported]@row <> \"//www.santa-greenland.com/community/discussion/3823/\", IF([Resolution Date]@row = \"//www.santa-greenland.com/community/discussion/3823/\", NETDAYS([Date Reported]@row, TODAY()), NETDAYS([Date Reported]@row, [Resolution Date]@row)))<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":109470,"type":"question","name":"Trying to get OR to work with Countifs","excerpt":"First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State =\"In Queue\" or \"In Process\". Current error I get is invalid operation. Have tried multiple iterations without luck. What am I missing? Thanks! =COUNTIFS({CNC, CMM, and BL Request Sheet Need by date},…","snippet":"First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State =\"In Queue\" or \"In Process\". Current error I get is…","categoryID":322,"dateInserted":"2023-08-25T15:27:49+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T17:16:16+00:00","insertUserID":165685,"insertUser":{"userID":165685,"name":"Wade Herrin","title":"Cell Leader","url":"https:\/\/community.smartsheet.com\/profile\/Wade%20Herrin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Ztvd2bxcfH4!c6jdhwhyx7Q!hsgJTX6RzVB","dateLastActive":"2023-08-25T18:16:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":13,"score":null,"hot":3385962845,"url":"https:\/\/community.smartsheet.com\/discussion\/109470\/trying-to-get-or-to-work-with-countifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109470\/trying-to-get-or-to-work-with-countifs","format":"Rich","lastPost":{"discussionID":109470,"commentID":392637,"name":"Re: Trying to get OR to work with Countifs","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392637#Comment_392637","dateInserted":"2023-08-25T17:16:16+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+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":"2023-08-25T17:07:38+00:00","dateAnswered":"2023-08-25T17:07:32+00:00","acceptedAnswers":[{"commentID":392632,"body":"

Nailed it, thank you!<\/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":109468,"type":"question","name":"Compare duplicate rows, identify most recently added","excerpt":"I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date is extended. I'd like to identify the oldest added duplicate to the sheet so that I can create a workflow to move it to my archive sheet. Thank…","snippet":"I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date…","categoryID":322,"dateInserted":"2023-08-25T15:12:16+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:33:42+00:00","insertUserID":138358,"insertUser":{"userID":138358,"name":"Stefanie S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stefanie%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T15:56:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3385959358,"url":"https:\/\/community.smartsheet.com\/discussion\/109468\/compare-duplicate-rows-identify-most-recently-added","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109468\/compare-duplicate-rows-identify-most-recently-added","format":"Rich","lastPost":{"discussionID":109468,"commentID":392620,"name":"Re: Compare duplicate rows, identify most recently added","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392620#Comment_392620","dateInserted":"2023-08-25T16:33:42+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+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\/VIINAL1P3WNF\/screenshot-2023-08-25-at-11-08-09-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-08-25 at 11.08.09 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T15:58:16+00:00","dateAnswered":"2023-08-25T15:52:39+00:00","acceptedAnswers":[{"commentID":392600,"body":"

This should work with only one caveat... if multiple entries have the same date and time (down to the minute), they will not be marked as duplicates.<\/p>

=IF(AND([Created]@row <> \"//www.santa-greenland.com/community/discussion/3823/\", NOT([Created]@row = MAX(COLLECT(Created:Created, ID:ID, ID@row)))), 1, 0)<\/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":[]}">

Trending Posts

  • Help with date calculation formula

    Hello, I'm trying to find a formula that will help me calculate how long an intake took to resolve. The rows I need to be calculated are Date Reported & Resolution Date. If the resolution date is blank I want it to use the current date in the calculation to see how long this issue has gone unresolved. Any help is much…

  • Trying to get OR to work with Countifs

    First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State ="In Queue" or "In Process". Current error I get is invalid operation. Have tried multiple iterations without luck. What am I missing? Thanks! =COUNTIFS({CNC, CMM, and BL Request Sheet Need by date},…

  • Compare duplicate rows, identify most recently added

    I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date is extended. I'd like to identify the oldest added duplicate to the sheet so that I can create a workflow to move it to my archive sheet. Thank…