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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives