SmartSheet Dashboard: Enter a value, have data autofill

Is there a way to build a SmartSheet Dashboard, and have a field that we can enter a value (say a project #) and have the corresponding fields autofill/populate as a result of that action? Or have a dropdown that autofills with all of the project #'s, we select one and then the corresponding fields populate from that selection?
Answers
-
Hi @Bangert -- as far as I know, Dashboards are exclusively for viewing and you can't change any data in them. You can, however, do this with a report or another sheet. Use the INDEX/COLLECT functions to pull in the data you want, based on whatever pulldown you create. Here's how to use the INDEX function -- this article contains directions for using COLLECT inside the function:
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives