Hi all!
I am somewhat struggling with a "data between cells" case that I cannot seem to figure out.
I want to create a couple of forms that can be used to fill in information about a site visit.
I have a sheet where the projectinfo is stored such as: client name, location, etc.
The form that I've created to be filled out during a site visit is a room based forms to collect info about a room within a project.
To keep the data together in the end I would like to have a link in this form that looks up info in the first sheet containing the project info.
Ideally that would be a dropdown containing this information, but as I've already found online this isn't a possibility with Smartsheet currently.
Is there a workaround to being able to select customer/project data in a form coming from a different sheet?
