Hyperlinks Don't Work in Portfolio WorkApps?

Samuel Mueller
Samuel Mueller ✭✭✭✭✭✭
inSmartsheet Basics

Is it just me, or do hyperlinks not work if you are in a Portfolio WorkApp? Referring to hyperlinks where you are linking to another Smartsheet sheet or report, etc..

Tags:
· Share on Facebook Share on Twitter

Answers

  • Brian_Richardson
    Brian_Richardson Overachievers

    They work for me… we expose the link to the project dashboard in our executive dashboard, which is in the portfolio workapp on the main page. Those links work, I tried it just now.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

    · Share on Facebook Share on Twitter
  • Samuel Mueller
    Samuel Mueller ✭✭✭✭✭✭
    edited 06/23/23

    @Brian_Richardsonwhat about links that are in sheets? Not in/on a dashboard

    · Share on Facebook Share on Twitter
  • Brian_Richardson
    Brian_Richardson Overachievers

    Hi yes links on a sheet work in Workapps for me. The first screen below shows links on a sheet that’s open in Workapps. When I click them, it opens the destination directly..shown in second screen. This is on mobile too…I know it works on desktop as well.


    IMG_4864.png
    IMG_4865.png


    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

    · Share on Facebook Share on Twitter
  • Samuel Mueller
    Samuel Mueller ✭✭✭✭✭✭

    @Brian_Richardsonso that's a sheet link from a report, I'm referring to an actual hyperlink you create - like below. These are the only types of links I am having issues with. Sorry, I should have been more clear!


    image.png


    · Share on Facebook Share on Twitter
  • Brian_Richardson
    Brian_Richardson Overachievers

    Aaaah, ok I'm with you now. And this is very interesting. I'm seeing issues too.

    After doing a bunch of testing it appears that the issue is hyperlinks created to Smartsheet Content. Those disappear when viewing in Workapps. However, hyperlinks created to URLs work fine in Workapps.

    It's all Workapps, not just Portfolio Workapps, that have this issue. I never noticed it before!

    Sucks - we use the Smartsheet Content hyperlinks all the time with Control Center, CC will change them to point to the correct new copies of templates. However CC will not change URL hyperlinks.

    First screen is a sheet of hyperlinks viewed directly in Smartsheet. Second screen is the same sheet viewed in a Workapp.

    • The Instructions is a URL link to a Google Site.
    • The Workapp Link is a cell-linked hyperlink, brought in from a sheet of profile data, where the profile data has a URL hyperlink pointing to the project's workapp.
    • The EIT Status Rules is a URL link to a published sheet.
    image.png
    image.png


    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

    · Share on Facebook Share on Twitter
  • Samuel Mueller
    Samuel Mueller ✭✭✭✭✭✭

    @Brian_RichardsonOkay thank you for confirming! That's what I'm seeing too. I just wanted to make sure it wasn't a glitch on my end. Going to have to submit this enhancement request

    · Share on Facebook Share on Twitter

Categories

Perfect. Thank you so much!<\/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":106958,"type":"question","name":"Datamesh very slow to update","excerpt":"Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?","snippet":"Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have…","categoryID":321,"dateInserted":"2023-06-27T15:05:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T21:09:27+00:00","insertUserID":161700,"insertUser":{"userID":161700,"name":"Jagdeep","url":"https:\/\/community.smartsheet.com\/profile\/Jagdeep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:01:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":15741,"lastUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:07:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3375780270,"url":"https:\/\/community.smartsheet.com\/discussion\/106958\/datamesh-very-slow-to-update","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106958\/datamesh-very-slow-to-update","format":"Rich","tagIDs":[219,334,381],"lastPost":{"discussionID":106958,"commentID":382703,"name":"Re: Datamesh very slow to update","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382703#Comment_382703","dateInserted":"2023-06-27T21:09:27+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:07:50+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T21:04:31+00:00","dateAnswered":"2023-06-27T19:57:59+00:00","acceptedAnswers":[{"commentID":382687,"body":"

Hi @Jagdeep<\/a> - Unfortunately, my experience has been that Datamesh \"Immediate\" can take up to 5 minutes (perhaps more).<\/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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":381,"urlcode":"DataMesh","name":"DataMesh"}]},{"discussionID":106941,"type":"question","name":"How to show data of previous working day?","excerpt":"For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday. =COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, \"Close Gap\", {Customer Escalation Request Date}, TODAY(-1)) I'm…","snippet":"For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday.…","categoryID":321,"dateInserted":"2023-06-27T10:29:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T12:02:55+00:00","insertUserID":162184,"insertUser":{"userID":162184,"name":"Sachiko Kagami","title":"Customer Service Manager","url":"https:\/\/community.smartsheet.com\/profile\/Sachiko%20Kagami","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:25:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3375730935,"url":"https:\/\/community.smartsheet.com\/discussion\/106941\/how-to-show-data-of-previous-working-day","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106941\/how-to-show-data-of-previous-working-day","format":"Rich","lastPost":{"discussionID":106941,"commentID":382502,"name":"Re: How to show data of previous working day?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382502#Comment_382502","dateInserted":"2023-06-27T12:02:55+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:11:22+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T11:47:48+00:00","dateAnswered":"2023-06-27T11:40:22+00:00","acceptedAnswers":[{"commentID":382497,"body":"

Hi @Sachiko Kagami<\/a>,<\/p>

The WORKDAY function is what you're after here.<\/p>

\n \n https:\/\/help.smartsheet.com\/function\/workday\n <\/a>\n<\/div>

In your case, I think the following should work:<\/p>

=COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, \"Close Gap\", {Customer Escalation Request Date}, WORKDAY(TODAY(),-1)<\/p>

This will do the check for yesterday, skipping weekends. Public holidays aren't automatically in there, but you can add these as per the link.<\/p>

Hope this helps - if there are any issues then just post! 😊<\/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":[]}],"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":5416,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet

  • Case sensitivity when using data mesh

    I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…

  • Datamesh very slow to update

    Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?

  • How to show data of previous working day?

    For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday. =COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, "Close Gap", {Customer Escalation Request Date}, TODAY(-1)) I'm…