Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
How to create a chart widget for status (Green, yellow, red)?
Alex Molina
✭✭
Hello,
I have a picture of what I want to do, but can't with the selected data set. I tried, but it said data cannnot be charted. I selected the data range primary and status.
Tags:
Answers
-
I use a metric sheet to roll up some of that data, and then pull my chart from the Metrics. You would pull it as data (a number) and then in the chart widget, you would color it there.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
