using external data in a form and sheet and for validation
Our company has an internal application. I would like to reference this application's data in a form and in a sheet:
- When a user is submitting a form, it lets them select a value from a drop down that is populated from data in this external application
- When a user is submitting a form, it lets them enter free-form text that is cross-referenced/validated against the external data to verify the user entered valid data (an internal ticket ID for example)
- After a user submits a form and a row is added to a sheet, some columns are auto populated with data that comes from the external data
Is this possible using Smartsheet and if so, how?
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.