Auto-populate field based on the form input field
Is there any way in Smartsheet that a form linked to the sheet will get input from the user and lookback into the same sheet imported to form and provide the users with the dropdown for the input field provided by the user?
Example: A excel sheet is containing email id and the reports created by the email id in a tableau(say) server. A sheet with all the existing email id's and report names are created and that is imported to Smartsheet forms. In the form if the user enters his email Id, the form should lookback into the sheet and fetch only the reports created by the mail id in that server and provide in a dropdown manner in the forms.
Is any solution available for this?