I am building a responsibility tracker in Smartsheet. Team members complete a single intake form where they list up to five responsibilities, and under each responsibility up to three expectations (e.g., Responsibility 1 with Expectation 1A, 1B, 1C; Responsibility 2 with 2A, etc.). I’ve already built a Tracker sheet that is designed to store one row per expectation, with columns for Employee, Supervisor, Property, Responsibility, Expectation, Due Date, Status, Completed, and Archived. I’ve also built property dashboards and reports off the Tracker sheet that group by Responsibility so expectations display underneath the correct responsibility (for example, Responsibility 1 showing rows for 1A and 1B individually). The goal is for each expectation to exist as its own row so it can be tracked, edited from dashboards, and filtered by Current User and Supervisor.
What I’m trying to solve is how to take one wide intake submission (multiple responsibility/expectation blocks in a single row) and automatically split it into multiple rows in the Tracker sheet—each row pairing the correct Responsibility with each non-blank Expectation. I’ve been attempting this with Bridge but am struggling with trigger configuration and workflow structure. Is Bridge the best approach for splitting structured row data like this, or is there a cleaner architectural method to achieve one submission → multiple expectation rows?
