I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a unique project manager and project name. While I can build the survey questions, I have not been able to figure out if there is a way to customize the specific webform title, headers or even column properties based on the values on a within a unique row to include column properties, or customize a webform header. I may be looking at this all wrong and there may be a better way to do this. Below is the basic structure of the sheet. Any input is appreciated. Thanks.
Sample SmartSheet Structure
Column 1 : Question - Please evaluate <Insert PM Name>'s performance on the <Insert Project Name>?
Column 1 is a drop down list with ratings 1-5.
Column 2: PM Name
Column 3: Project Name