Auto-populate field based on the form input field

Jeya Bharathi

Hi All,

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?

Andrée Starå

Hi @Jeya Bharathi

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jeya Bharathi

Thanks @Andrée Starå

Andrée Starå

@Jeya Bharathi

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!