SmartSheet Dashboard: Enter a value, have data autofill

Bangert

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?

Lucas Rayala

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:

INDEX Function | Smartsheet Learning Center