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.

Printing a Sight

24

Comments

  • Daniel Stein
    Daniel Stein Employee
    edited 07/29/16

    Thank you Clare for the feedback -- we are indeed working on a print solution for Sights.

    In the meantime, I would recommend using a snipping tool to save an image of a Sight when desired. Windows 7, 8, and 10 have a built insnipping toolthat saves an image of part of your screen. Mac OS also has built inscreen snippingvia a keyboard shortcut. These tools are quite easy to use, so I would recommend giving them a try if you haven't already.

    I hope this helps. Thanks again for your input.

    · Share on Facebook Share on Twitter
  • Oswaldo Rojas
    Oswaldo Rojas ✭

    No printing feature for Sights is the only thing preventing us to upgrade to Enterprise license.

    · Share on Facebook Share on Twitter
  • Daniel Stein
    Daniel Stein Employee

    Thanks Oswaldo for the feedback. We're working on print support for Sights, and it should be available in either September or October. In the meantime, you may try using the screen snipping tools I mentioned in my post just above.

    Best regards,

    Daniel

    · Share on Facebook Share on Twitter
  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    Great News!!

    · Share on Facebook Share on Twitter
  • Dietrich Koch
    Dietrich Koch ✭✭✭✭✭✭

    Hey Daniel,

    these are really awesome news!!!

    Thanks!

    Dietrich

    · Share on Facebook Share on Twitter
  • Tony Renfrow
    Tony Renfrow ✭
    edited 08/12/16

    I joined this community specifically to figure out how to print a new Sight. Clearly a lot of people want this...

    In the mean time, if I'm using a snipit screen capture, the background in the Sight window is a light gray, so my capture has a gray background. Is there a way to make the Sight have white widgets on a white background? I can't find it in any setting.

    Thanks

    · Share on Facebook Share on Twitter
  • Rebecca Bex Vasquez
    Rebecca Bex Vasquez ✭

    So glad I am not the only one with this issue. I do end up taking a screenshot of my sights weekly to ensure I can provide a "one pager" for our senior leaders. Add my vote for this added feature!

    · Share on Facebook Share on Twitter
  • Daniel Stein
    Daniel Stein Employee

    Thanks Rebecca for your input!

    We're actively working on the Print feature for Sights and are aiming to release it in the next month or so, so stay tuned.

    Tony, we're also working on the ability to choose a white background for Sights and hope to release that in the next couple of months.

    Best regards,

    Daniel

    · Share on Facebook Share on Twitter
  • Tony Renfrow
    Tony Renfrow ✭

    Rebecca Bex VasquezI have done a similar thing then I started using Snipit (standard snipping tool) in MS Office to simply take clips and drag them over into a word document for my weekly dashboard reports. I configure about 3 or 4 Reports that are automatically updated from the Sheet. Doing this to a word doc looks way more pro-grade than the snip/screenshot of all the sight info. Just a suggestion...

    Thanks, Daniel.

    · Share on Facebook Share on Twitter
  • Matheus Dias
    Matheus Dias ✭✭

    Hello. Just use the extension Fire Screen Shot in Firefox.

    Let the sight with full-screen preview and then use the shortcut to trigger FireShotSecreen extension (CTR + SFT + ALT + Z).

    It will show an edit screen. Now, just save as PDF or image.

    · Share on Facebook Share on Twitter
  • Rebecca Bex Vasquez
    Rebecca Bex Vasquez ✭

    Thanks Daniel, Tony & Matheus! Great suggestions. I don't typically use Firefox but I will give that a try today.

    My company uses Snag It which allows me to save each sight into a PowerPoint deck and edit sections as needed. I have been going between this and screenshots depending on the audience.

    Can't wait for the new feature.

    · Share on Facebook Share on Twitter
  • Matheus Dias
    Matheus Dias ✭✭

    Rebecca, you can also do with Google Chrome.

    · Share on Facebook Share on Twitter
  • Jennifer Greenough
    Jennifer Greenough Overachievers Alumni
    edited 09/29/16

    We are in our final evaluation of PPM Software, and the inability to print Sights may make it a no go for us. We need to use Sights to generate compiled reports for donors, and while seeing real-time information is great for the teams and internal managment, Donor Reports need to be PDF'd for record keeping. Where is this in the queue of improvements? I see that this conversation has been ongoing for a while and the September update allows for Publishing, but still not printing. Any updates here?

    · Share on Facebook Share on Twitter
  • Daniel Stein
    Daniel Stein Employee

    只是一个快速更新:我们目前跟踪release Sight Print in the November timeframe.

    Best regards,

    Daniel

    P.S. Sometimes feature release dates shift, so we can't promise a specific date, but hopefully this estimate helps.

    · Share on Facebook Share on Twitter
  • Stephanie Taylor
    Stephanie Taylor ✭✭✭✭✭✭

    Yeah!!!!!

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

Categories

Nevermind, I resolved it!<\/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"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"}]},{"discussionID":107817,"type":"question","name":"How to get the formulas to correctly count the completed tasks?","excerpt":"The current formula counts every task for the total. =COUNTIF(DESCENDANTS([Planning Done]@row), 1) + \" of \" + COUNT(CHILDREN([Task\/Topic]@row)) + \" Done\" I have been trying to get it to only count when all subtask from its proper row have been completed. There are 4 tasks and over 60 subtasks. When the subtasks are…","snippet":"The current formula counts every task for the total. =COUNTIF(DESCENDANTS([Planning Done]@row), 1) + \" of \" + COUNT(CHILDREN([Task\/Topic]@row)) + \" Done\" I have been trying to get…","categoryID":322,"dateInserted":"2023-07-19T19:04:08+00:00","dateUpdated":"2023-07-19T19:16:18+00:00","dateLastComment":"2023-07-19T19:40:18+00:00","insertUserID":163690,"insertUser":{"userID":163690,"name":"Ruvalcaba12","url":"https:\/\/community.smartsheet.com\/profile\/Ruvalcaba12","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-19T19:35:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163690,"lastUserID":163690,"lastUser":{"userID":163690,"name":"Ruvalcaba12","url":"https:\/\/community.smartsheet.com\/profile\/Ruvalcaba12","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-19T19:35:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":37,"score":null,"hot":3379592666,"url":"https:\/\/community.smartsheet.com\/discussion\/107817\/how-to-get-the-formulas-to-correctly-count-the-completed-tasks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107817\/how-to-get-the-formulas-to-correctly-count-the-completed-tasks","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107817,"commentID":386077,"name":"Re: How to get the formulas to correctly count the completed tasks?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386077#Comment_386077","dateInserted":"2023-07-19T19:40:18+00:00","insertUserID":163690,"insertUser":{"userID":163690,"name":"Ruvalcaba12","url":"https:\/\/community.smartsheet.com\/profile\/Ruvalcaba12","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-19T19:35:39+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\/2N6H1QH5FWDV\/screenshot.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ScreenShot.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T19:24:31+00:00","dateAnswered":"2023-07-19T19:19:24+00:00","acceptedAnswers":[{"commentID":386066,"body":"

@Ruvalcaba12<\/a> try his<\/p>

Create a helper column called \"Helper\" and put this column formula<\/p>

=IF(COUNT(CHILDREN([Planning Done]@row)) = 0, \"//www.santa-greenland.com/community/discussion/comment/\", IF(COUNT(CHILDREN([Planning Done]@row)) = COUNTIF(CHILDREN([Planning Done]@row), 1), 1, 0))<\/p>

Then in your top level put this formula<\/p>

=COUNTIFS(CHILDREN(Helper@row), 1) + \" of \" + COUNT(CHILDREN()) + \" Done\"<\/p>"},{"commentID":386074,"body":"

@Ruvalcaba12<\/a> Maybe if you change the text of your second tier children to this or something similar<\/p>

=IF(COUNT(CHILDREN([Planning Done]@row)) = COUNTIF(CHILDREN([Planning Done]@row), 1), \"Complete\", COUNTIFS(CHILDREN([Planning Done]@row), 1) + \" of \" + COUNT(CHILDREN([Task\/Topic]@row)) + \" Done\")<\/p>

Then your top tier would be <\/p>

=COUNTIFS(CHILDREN(), \"Complete\") + \" of \" + COUNT(CHILDREN()) + \" Done\"<\/p>"},{"commentID":386075,"body":"

You could keep the number but you have to change something to distinguish. Second Tier:<\/p>

=IF(COUNT(CHILDREN([Planning Done]@row)) = COUNTIF(CHILDREN([Planning Done]@row), 1), COUNTIFS(CHILDREN([Planning Done]@row), 1) + \" of \" + COUNT(CHILDREN([Task\/Topic]@row)) + \" Complete\", COUNTIFS(CHILDREN([Planning Done]@row), 1) + \" of \" + COUNT(CHILDREN([Task\/Topic]@row)) + \" Done\")<\/p>

Top tier:<\/p>

=COUNTIFS(CHILDREN(), CONTAINS(\"Complete\", @cell)) + \" of \" + COUNT(CHILDREN()) + \" Done\"<\/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":107813,"type":"question","name":"IFERROR INDEX COLLECT if greater than 0 issue","excerpt":"I am trying to collect from a separate sheet the counts of holds if the site matches and if the count of holds is greater than 0. I am trying to collect the Count of holds if the site matches if the count of holds is greater than 0. Can someone please help me try to collect this. I tried below and did not work:…","snippet":"I am trying to collect from a separate sheet the counts of holds if the site matches and if the count of holds is greater than 0. I am trying to collect the Count of holds if the…","categoryID":322,"dateInserted":"2023-07-19T18:06:25+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T18:21:20+00:00","insertUserID":159528,"insertUser":{"userID":159528,"name":"tchav","url":"https:\/\/community.smartsheet.com\/profile\/tchav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-19T19:34:37+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-07-19T19:26:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":13,"score":null,"hot":3379582665,"url":"https:\/\/community.smartsheet.com\/discussion\/107813\/iferror-index-collect-if-greater-than-0-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107813\/iferror-index-collect-if-greater-than-0-issue","format":"Rich","tagIDs":[254,292],"lastPost":{"discussionID":107813,"commentID":386039,"name":"Re: IFERROR INDEX COLLECT if greater than 0 issue","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386039#Comment_386039","dateInserted":"2023-07-19T18:21:20+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-07-19T19:26:27+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\/D4NN11PJQ4TD\/screenshot-2023-07-19-110100.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-07-19 110100.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T18:18:02+00:00","dateAnswered":"2023-07-19T18:10:56+00:00","acceptedAnswers":[{"commentID":386031,"body":"

Your syntax is off, and you shouldn't need a MATCH function if you are using a COLLECT function.<\/p>

=IFERROR(INDEX(COLLECT({Count of Holds}, {Count of Holds}, @cell> 0, {Site}, @cell = Site@row), 1), \"//www.santa-greenland.com/community/discussion/comment/\")<\/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"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"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

  • COUNTIF Issue on Sheet Summary

    I am trying to see how many times Q1, Q2, Q3, and Q4 appear in my "Quarter" column on my sheet within my sheet summary. I am using the formula =COUNTIF([Quarter:Quarter], "Q1") to try to get just Q1 and it is not working. Any suggestions on why that is not working?

  • How to get the formulas to correctly count the completed tasks?

    The current formula counts every task for the total. =COUNTIF(DESCENDANTS([Planning Done]@row), 1) + " of " + COUNT(CHILDREN([Task/Topic]@row)) + " Done" I have been trying to get it to only count when all subtask from its proper row have been completed. There are 4 tasks and over 60 subtasks. When the subtasks are…

  • IFERROR INDEX COLLECT if greater than 0 issue

    我想收集从一个单独的表counts of holds if the site matches and if the count of holds is greater than 0. I am trying to collect the Count of holds if the site matches if the count of holds is greater than 0. Can someone please help me try to collect this. I tried below and did not work:…