Automated Row Additions to Hierarchy

jgneely72151

Is there a way for Smartsheet to automatically add rows to an hierarchy? Is this such a thing?

I am trying to restructure a massive database where the courses and course information is listed in columns. We have 3 possible courses a student can take and course 1, course 2 and course 3 are it's own column. I'd like for the course to be it's own row under one course column. Right now, it would mean someone would have to automatically add the rows for a hierarchy. Just wondering if the rows could automatically be added based on the number of courses enrolled.

This would save a lot of trouble by not having to manually add blank rows during the admittance stage. Now if a student fails, then we would could manually add a row for a retake test but we want some automation here.

Hoping for a better work around because it has become cumbersome trying to track this in multiple columns as opposed to separate sub records for the student.

The link is a sample of what I'd like for our sheet to appear.

https://app.smartsheet.com/b/publish?EQBCT=f0ac09e2db0c47a6a6815b87403686f8

Any feedback is greatly appreciated!

Jennifer

Paul Newcome

You will need to leverage the API or the premium add-on Bridge for this.

Paul Newcome

You will need to leverage the API or the premium add-on Bridge for this.

jgneely72151

Thanks so much! We have Enterprise but not sure if Bridge is included. I'll look into that. Again, thanks!

Paul Newcome

Happy to help. 👍️