How to chart with forms survey?
Hello-
Iam newer to Smartsheet.. and I have created a form for our HR department doing 30 day reviews with employees. I would like to be able to chart by response (scale of 1-5). Sample of data is included below.
Has anyone been able to do this before?
Answers
-
@araines Are you trying to chart just the numbers "1, 2, 3, 4, and 5" and the quantity of each without the associate text?
If so, you'd have to extract the number into another column.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen how would you suggest extracting the numbers to another column?
-
@araines You can use teh left function and just set the number of characters to 1 for your application
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives