How can I move columns from a row to individual tasks/ rows in a different sheet?
I am trying to conduct a survey at 100+ locations and use the survey results to generate a "custom" action plan for each site based on the responses. Once the action plan/ task list has been created I will need to track the project status of the task completion. The logic for the action plans is easy to address. I'm having issues figuring out how to convert the column based responses from the Smartsheet form/ survey into individual tasks that can be tracked and built into various reports based on location and relevancy to different teams. I gave a simplified version below, but in practice there are about 50 questions on the survey and 100+ locations so I'm trying to limit the amount of manual intervention.
Any help or thoughts would be greatly appreciated.
For a simple example:
- Are the lights on? Yes/ No
- Is there coffee? Yes/ No/ Unsure
- Are the walls blue? Yes/ No
Action Plan per site:
- If yes, turn them off.
- If <> yes, order more coffee.
- If no, paint the walls blue.
Help Article Resources
Check out the Formula Handbook template!