Free Text Field for Location in Smartsheet
Is there a way to create a report and widget for a dashboard that will illustrate the number of requests per location based on form that is free test?
Tags:
Answers
-
Perhaps add a column of type dropdown by US state or possibly US region (west, midwest, south, etc.) and then the free-form text field? That way you can do two things from a dashboarding perspective:
- Surface the number of requests per location within your constrained dropdown, and
- Surface a report of the free field GROUPED BY that constrained dropdown.
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!