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
Sights look to be a great addition to smartsheet. I am currently in a 10-day trial but I dont see an option for printing the sight. My thought is that it would make a good cover sheet to our status reports going forward. Is this currently an option that Im missing?
Comments
-
Dietrich Koch ✭✭✭✭✭✭Vote me in for that feature!!
Sights are a great tool to not only have a permanently up to date infoscreen but also to give a comprehensed weekly/monthly report.
But the possibility to "save as pdf" or "print" is a essential for any kind of regular reporting. Since Smartsheet already supports exporting to pdf / printing with every sheet or report, I do not understand, why it's not possible with sights.
I sincerely hope that this feature is already on the roadmap for the near future...
-
Travis EmployeeThis is a great request that I will pass along!
In the meantime, you could take a screenshot of the Sight and use the resulting image file for your cover sheet.
-
Stephanie Taylor ✭✭✭✭✭✭I would also like to add my vote to access sights from my smartphone.
-
Travis Employee
Stephanie - this is coming soon!
-
Stan Adell ✭✭I have worked hard to create some useful sights. It will be helpful when we can print them for a meeting.
-
I agree with everyone here. This is a must have feature!
-
I'm adding my voice to the chorus - printing is an essential feature to Sights, not only to be able to share by PDF, but to be able to create progress snapshots. Sights is an incredible feature but we need to be able to print to make it fully functional in our workflow. So much of our data changes daily, and I need to be able to create static snapshots of monthly progress for reporting, and distribution purposes. I hope this is in the HOT queue. Any estimate on a rollout date for this feature?
-
Travis Employee
Mary, I dont have any information on this but I will update this thread when I have information I can share!
-
Completely agree. I would like to have the possibility to print as a weekly report is very useful
-
I agree! We need a way to print sights to present and store.
-
Deirdre Spencer ✭✭✭Joining the chorus. Just spent an afternoon setting up Sights for my team, and was chagrined to discover I can't print to PDF to archive our weekly status. Screenshots are a very poor workaround. Travis, we're three months out from your saying in March that this is coming soon. Can we please get an update on the ETA for this essential enhancement? Thank you!
-
Stephanie Taylor ✭✭✭✭✭✭
I did a snipit of the sight. It's not the best solution but at least it's something.
-
Wondering if the folks from SmartSheet can provide an update on this topic? The Sights feature has been an amazing solution for us in tracking our KPIs, but without the ability to print - or export into PowerPoint - it really hampers how we can share our results with others in the organization.
-
Daniel Stein EmployeeThanks for the questions about Sights Print. We're actively working on a couple of features in this area:
- Sights Publish, which we expect to be able to ship in August. Similar to Sheet Publish, this will allow you to generate a live link to a Sight that anyone can view, without logging into Smartsheet. The Sight can also be embedded in other web pages.
- Sights Save as PNG. We're actively working on this but don't yet have a specific release date. We realize this is an important feature for folks and appreciate the feedback. Until this is ready, taking a screen clipping is a workaround, as Stephanie mentions, though we realize it isn't ideal. Once we release Publish, that will also be a good solution in many scenarios.
Thanks again for the Sights feedback, and please keep it coming.
Daniel Stein
Product Manager
-
I completely agree - being able to save or print a Sights pdf copy is essential. Not being able to preserve an historic record of previous publications is an issue for our business processes.
I / my business are new to using Smartsheets & Sights - everything about the experience so far has created very positive interest, but the inability to export to PDF is perceived as the single biggest drawback. Please, please, please can this be flagged as an urgent enhancement.
Thank you
Categories
=IF(COUNTIF(CHILDREN([BallCell]@row), \"Empty\") = COUNT(CHILDREN([BallCell]@row)), \"Not Started\", IF(COUNTIF(CHILDREN([BallCell]@row), \"Full\") = COUNT(CHILDREN([BallCell]@row)), \"Completed\", \"In Progress\"))<\/p>
If you do have your sheet setup somehow so that the entries are respresented by [0, 0.25, 0.50, 0.75, 1], then this should work:<\/p>
=IF(COUNTIF(CHILDREN([BallCell]@row), < 0.25) = COUNT(CHILDREN([BallCell]@row)), \"Not Started\", IF(COUNTIF(CHILDREN([BallCell]@row), 1) = COUNT(CHILDREN([BallCell]@row)), \"Completed\", \"In Progress\"))<\/p>
In either case, you will need to substitute [BallCell] with the name of the column with your symbols. The column name is not visible in your screenshot.<\/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":106869,"type":"question","name":"Formula to Assign Symbol based on a cell's value","excerpt":"This is a complicated one that I once got to work with RGY balls, but cannot figure out how to apply this to the Pain scale emojis. What I am trying to do: (Using the pain scale symbols) Have symbols automatically changed based on the value in the corresponding cell. I am already using a formula to assign a value based on…","categoryID":322,"dateInserted":"2023-06-24T20:02:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-25T22:29:54+00:00","insertUserID":158092,"insertUser":{"userID":158092,"name":"MeganJF","url":"https:\/\/community.smartsheet.com\/profile\/MeganJF","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DgFow9e-1vo!YfMmmJOUTjo!UDpVBcB6ikY","dateLastActive":"2023-06-25T17:43:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":139601,"lastUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2023-06-26T02:59:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":27,"score":null,"hot":3375372134,"url":"https:\/\/community.smartsheet.com\/discussion\/106869\/formula-to-assign-symbol-based-on-a-cells-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106869\/formula-to-assign-symbol-based-on-a-cells-value","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106869,"commentID":382193,"name":"Re: Formula to Assign Symbol based on a cell's value","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382193#Comment_382193","dateInserted":"2023-06-25T22:29:54+00:00","insertUserID":139601,"insertUser":{"userID":139601,"name":"jmyzk_cloudsmart_jp","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jmyzk_cloudsmart_jp","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZBVD3K8PY0D5\/n7CZ1F4XWEM9Y.JPG","dateLastActive":"2023-06-26T02:59:31+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-25T17:10:13+00:00","dateAnswered":"2023-06-25T03:32:30+00:00","acceptedAnswers":[{"commentID":382165,"body":"
Hi @MeganJF<\/p>
I guess you forget to use AND( ).<\/p>
For example, <\/p>
- IF([Total Value to User Score]@row = <3.8, >4.7, \"Mild,<\/li><\/ul>
should be<\/p>
- IF(AND(<\/strong>[Total Value to User Score]@row < 3.8, [Total Value to User Score]@row > 4.7)<\/strong>, \"Mild\",<\/li><\/ul>
However, the following would be more straightforward.<\/p>
- =IF([Total Value to User Score]@row >= 4.8, \"No Pain\", <\/li>
- IF([Total Value to User Score]@row >= 3.8, \"Mild\", <\/li>
- IF([Total Value to User Score]@row >= 2.8, \"Moderate\", <\/li>
- IF([Total Value to User Score]@row >= 1.8, \"Very Severe\", <\/li>
- IF([Total Value to User Score]@row < 1.8, \"Extreme\", \"//www.santa-greenland.com/community/discussion/4502/\")))))<\/li><\/ul>
- IF(AND(<\/strong>[Total Value to User Score]@row < 3.8, [Total Value to User Score]@row > 4.7)<\/strong>, \"Mild\",<\/li><\/ul>
![\"Formula](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/N18M5WZN6TYQ\/formula-to-assign-symbol-based-on-a-cell-27s-value.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
