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.

Sheets, or partial sheets displayed in 'Sights' dashboard

Brian Smith
Brian Smith ✭
edited 12/09/19 inArchived 2016 Posts

我知道我们几个使用t细胞连接o creat roll-up reports of our data, but these reports cannot be displayed in a 'Sight', becase they live on a sheet, not on a report.

Is there a way, or can i recommend a functionality, that allows for a sheet, or part of a sheet to be put into a sight for quick visibility?

Unfortunately, my report can't be displayed because it was not created as a "Report".

Thanks,

B

Tags:
· Share on Facebook Share on Twitter

Comments

  • Christine Oakes
    Christine Oakes ✭
    edited 04/11/16

    Brian

    You can create a Sheet Data widget in your Sight and pull in individual cells from your sheet.

    Christine

    · Share on Facebook Share on Twitter
  • Christine Oakes
    Christine Oakes ✭

    Sorry Brian - meant Metric Widget, not Sheet data.

    · Share on Facebook Share on Twitter
  • Brian Smith
    Brian Smith ✭

    Thanks Christine. I'm looking for something that looks like the 'report' widget, where it shows up in a grid view.

    If I were to do a metric or sheet data widget, I would have 5 rows by 4 columns of data listed down the page (20 entries long, with no identifiable correlation between terms).

    B

    · Share on Facebook Share on Twitter
  • Brian Smith
    Brian Smith ✭

    My workaround:

    I have a source sheet, where I have a section at the bottom doing all of my formulas.

    I then cell link the formulated rows, and any others that I wish to have appear on my 'sight' to a 2nd sheet.

    From there, I create a report that reports against all cells in my 2nd sheet that 'are not blank' (essentially reporting the exact contents of my 2nd sheet - they are identical).

    So, unfortunately this workflow requires 2 sheets, & a report in order to get the information into my 'sight'.

    B

    · Share on Facebook Share on Twitter
  • Chuck Muirhead
    Chuck Muirhead ✭✭✭✭✭

    布莱恩,我觉得你的痛苦。没有大difference between Metric and Sheet Data widgets as they build vertically, which does not represent the sheet data I want to display, so I must create reports from various sheets and then add a report widget to the Sight. In my case, I have to create over 270 reports in order to place 3 unique pieces of data on 90 Sight Dashboards.....I love sights already, but there is a ton of up-front work and manipulation to get items to show up as I want on the Dashboard.

    · Share on Facebook Share on Twitter
  • Travis
    Travis Employee

    Hi everyone, this is something we are looking into adding to Sights in the future and I will submit your feedback to the team working on Sights!

    · Share on Facebook Share on Twitter
  • erangak
    erangak ✭

    Hi,

    What is the latest status of this feature? How soon can we see this?

    thanks,

    Eranga

    · Share on Facebook Share on Twitter
  • Joanna
    Joanna ✭

    +1

    Would love to display a section of a Sheet instead of a Report as a Dashboard widget. Sheets give me more flexibility to do things like Indent to create child rows, and format rows/columns/cells.

    I, too, am using a workaround and as a result, I am creating duplicates to satisfy the report criteria.

    · Share on Facebook Share on Twitter
  • Richard Heath
    Richard Heath ✭✭✭✭✭✭

    Hello,

    Has there been any further movement on this? The Metric widget reconfigures the Sheet Data in a format that doesn't suit our needs.

    Displaying a fixed range of cells from a Sheet would seem like the obvious solution.

    Richard.

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

Categories

No. In your formula from your post just before my last one, you were adding together 3 different joins. The first one has a different syntax from the 2nd and 3rd. The 2nd and 3rd have the correct syntax already.<\/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":109176,"type":"question","name":"How to check a box if exact text is found within a string of text","excerpt":"Hello, I am trying to place a check in a box when some exact text is found within a string of words. I am looking to place a check when \"TAC\" is found in a string of words. Here's the formula I am using, but its not working. No error message, but is not selecting the checkbox appropriately. =IF(HAS([Column Name1]@row,…","snippet":"Hello, I am trying to place a check in a box when some exact text is found within a string of words. I am looking to place a check when \"TAC\" is found in a string of words. Here's…","categoryID":322,"dateInserted":"2023-08-19T01:53:52+00:00","dateUpdated":null,"dateLastComment":"2023-08-19T17:54:54+00:00","insertUserID":149359,"insertUser":{"userID":149359,"name":"Jen H.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20H.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uzlXJ-dimro!oc1UqANVjEQ!GEwnp-NhEjM","dateLastActive":"2023-08-19T18:02:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":149359,"lastUser":{"userID":149359,"name":"Jen H.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20H.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uzlXJ-dimro!oc1UqANVjEQ!GEwnp-NhEjM","dateLastActive":"2023-08-19T18:02:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3384878926,"url":"https:\/\/community.smartsheet.com\/discussion\/109176\/how-to-check-a-box-if-exact-text-is-found-within-a-string-of-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109176\/how-to-check-a-box-if-exact-text-is-found-within-a-string-of-text","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109176,"commentID":391532,"name":"Re: How to check a box if exact text is found within a string of text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391532#Comment_391532","dateInserted":"2023-08-19T17:54:54+00:00","insertUserID":149359,"insertUser":{"userID":149359,"name":"Jen H.","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20H.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uzlXJ-dimro!oc1UqANVjEQ!GEwnp-NhEjM","dateLastActive":"2023-08-19T18:02:04+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-19T17:54:00+00:00","dateAnswered":"2023-08-19T02:33:27+00:00","acceptedAnswers":[{"commentID":391518,"body":"

HAS() will only return true under three conditions.<\/p>

  1. The cell is a multicontact cell and contains a match for the contact<\/li>
  2. The cell is a multiselect dropdown and contains a match<\/li>
  3. The cell is not a multicontact or multiselect dropdown and contains ONLY and EXACTLY the text you are matching against. <\/li><\/ol>

    I am assuming your row in question is a standard Text\/Number cell? If so, you will need to get somewhat creative with some CONTAINS() statements.<\/p>

    This will narrow down your matches to only cells that contain a space both before and after TAC. If, however, TAC can appear as the first or last \"word\" in the cell, it would not match in that circumstance as there would only be a space on one side.<\/p>

    =IF(CONTAINS(\" TAC \", [Column Name1]@row), 1, 0)<\/p>


    <\/p>

    If TAC can appear as the first or last \"word\" in the cell, this will cover those possibilities as well.<\/p>

    =IF(OR(CONTAINS(\" TAC \", [Column Name1]@row), LEFT([Column Name1]@row, 4) = \"TAC \", RIGHT([Column Name1]@row, 4) = \" TAC\"), 1, 0)<\/p>


    <\/p>

    If it is possible that TAC will be the exact entry of the cell, you will need an additional statement to cover that, as there would not be spaces on either side. This will add that option.<\/p>

    =IF(OR(CONTAINS(\" TAC \", [Column Name1]@row), LEFT([Column Name1]@row, 4) = \"TAC \", RIGHT([Column Name1]@row, 4) = \" TAC\", [Column Name1]@row = \"TAC\"), 1, 0)<\/p>


    <\/p>

    If there are other situations you may have in your sheet, i.e., TAC inside parenthesis, or before or after punctuation, etc, you will additional statements to include those options as well.<\/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":109146,"type":"question","name":"Identify Workflow from ID?","excerpt":"Good morning, got a random one. Is there any way to identify what sheet or workflow an automation ran from? I got a rogue automation this morning, and I don't know what sheet it lives in. However, I noticed at the bottom of the email, there is an ID number, similar to a sheet or row ID. Is there any way, maybe with the…","snippet":"Good morning, got a random one. Is there any way to identify what sheet or workflow an automation ran from? I got a rogue automation this morning, and I don't know what sheet it…","categoryID":321,"dateInserted":"2023-08-18T14:25:47+00:00","dateUpdated":null,"dateLastComment":"2023-08-19T08:29:31+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-08-18T20:30:29+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"lastUserID":161820,"lastUser":{"userID":161820,"name":"Hamza1","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Hamza1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-20T04:58:20+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":48,"score":null,"hot":3384804918,"url":"https:\/\/community.smartsheet.com\/discussion\/109146\/identify-workflow-from-id","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109146\/identify-workflow-from-id","format":"Rich","tagIDs":[227,334,448],"lastPost":{"discussionID":109146,"commentID":391519,"name":"Re: Identify Workflow from ID?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391519#Comment_391519","dateInserted":"2023-08-19T08:29:31+00:00","insertUserID":161820,"insertUser":{"userID":161820,"name":"Hamza1","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Hamza1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-20T04:58:20+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"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\/EYR2B79VH1AY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-18T19:37:53+00:00","dateAnswered":"2023-08-18T19:10:30+00:00","acceptedAnswers":[{"commentID":391468,"body":"

    Yeah. That does sound like it could take awhile. Haha. And if you knew the sheet I'd, you'd be able to just jump to it in SS instead of needing the api.<\/p>


    <\/p>

    Maybe a product enhancement request to expand the workflow portion of the api to include the sheet id is in order.<\/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":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]}],"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

    • Using Join(Collect to collect data from multiple sheets to populate in (1) cell

      I am looking to combine data from (3) sheets into one sheet. There will be 3 columns: Team, Assignment, and Notes The cells in the Team and Assignment columns from Sheet1, Sheet2 and Sheet3 are populated from a multi-select dropdown lists. Notes are free type. Example: p-id on the destination sheet is xx, Sheet1 and Sheet2…

    • How to check a box if exact text is found within a string of text

      Hello, I am trying to place a check in a box when some exact text is found within a string of words. I am looking to place a check when "TAC" is found in a string of words. Here's the formula I am using, but its not working. No error message, but is not selecting the checkbox appropriately. =IF(HAS([Column Name1]@row,…

    • Identify Workflow from ID?

      Good morning, got a random one. Is there any way to identify what sheet or workflow an automation ran from? I got a rogue automation this morning, and I don't know what sheet it lives in. However, I noticed at the bottom of the email, there is an ID number, similar to a sheet or row ID. Is there any way, maybe with the…