Welcome to the Smartsheet Forum Archives
这个论坛的帖子不再监视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.
Charts and Sights
Is there a way to get a Smartsheet Chart in a Sight?
Comments
-
Shaine Greenwood EmployeeHello AJ,
We don't have functionality for including a chart in a Sight but I'll add your vote for this to our enhancement request list for further consideration.
With that being said, if you have charting software or wish to use the charts labs integration with Smartsheet (disclaimer: labs apps are experimental and subject to breakage or removal without notice), you an take a screenshot of the chart you construct and add it to your Sight via the image widget.
保持mind that it will be a static image, and not a dynamically updating chart.
More on the labs apps can be found here:https://smartsheetlabs.com/
-
Chuck Muirhead ✭✭✭✭✭This was an immediate request from many members who purchased this feature. While we actively use sights in our company, it does not add a level of value that supercedes other options. When you have a product called "Sights", the assumption is data visibilty. without integrated charting or graphs, for me, it missed the mark and I have been hoping for an update to meet this need. I do inlcude "Pictures" from a third party business Intelligence app, but this means I need to take data from SmartSheet and import it into my app, then import an image from my app back into SmartSheet Sights. This costs time, which is money. I will be weighing my Sights ROI at my next payment cycle.
I am including a picture of our current Sight with chart images.
-
Brad Jones ✭✭✭✭✭✭Fully agree here. The ability to add live charts to the sights is truly critical.
The fact of human nature is that we are attracted to pictures. They are pretty, they provide instant context, and they provide instant perspective. A flat chart of numbers does not do much for most people because it takes time to digest.
+1 vote to charts within sights please. That is THE way to go.
-
Shaine Greenwood Employee
Hi Brad—
Got your vote down for dynamic charts in Sights as well.
-
Yoann ✭
Please add my vote to this one too, clearly a "must have" option
-
Shaine Greenwood Employee
@Chuck—sorryI didn't include you in my last post, I've passed your feedback on to our Product team. Thanks for your input!
@Yoann—gotyour vote down as well.
-
Please add my vote too.
-
Please add my vote
-
Shaine Greenwood Employee
Joanne and Jared—
I've got your votes down as well; thanks!
-
Please add my vote, thanks
-
Shaine Greenwood Employee
Hi Phil et all,
We've got a new way to submit feature enhancement requests. Check out the announcement on this for more information:https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests
-
+1 vote for dynamic charts in sights.
As a work around, I have been doing the screenshots and inserting the image, but I also edited the interaction and included a link to the chart I have in smartsheet labs so it is possible to see the current chart.
-
KathyH ✭✭
Agree. The whole point of a dashboard is to visualize data. Not having capabilities for charting misses the mark by a wide margin.
-
jdawson ✭✭
+1 vote for dynamic charts in sights.
Trying to sell this to my management team and having to export everything to chart is not the best sell. They like idea of dashboard reporting data from sheets as a visual.
-
Sasan EmployeeThank you all for your votes and your vote made an impact. We are currently working on adding and introducing a native and dynamic Chart widget. We will be showing a sneak preview in Engage, coming up in September 18-20.
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-25T22:30:12+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-25T22:30:12+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/6955/\")))))<\/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
