Higher Ed: degree planning using gannt view?

This was a really interesting one to figure out, thank you for posting it!  I can’t help feeling like my solution seems overly complicated though, hopefully someone else has a better idea

Here’s how it looks and here’s a link to the base, and you can duplicate the base into your own workspace to poke at it

To set this up, we’ll first need to create a linked field in Semesters and set up the Predecessor information so that we know which semester comes after which:

After that, we’ll set up the same thing in the Internships table as well:

To easily create Internship records, I would recommend using Record Templates to do this

After that, we’ll need to create two lookup fields in Internships:

1. A lookup field to display what the next semester would be
   1. From the Semesters table to display the ‘Successor: Semesters’ field
   2. Field name: Successor: Semesters (from Semesters)
2. A lookup field to display what the next semester would be for the previous internship
   1. From the ‘Predecessor - Internships’ linked field, displaying the lookup field from the previous step 
   2. Field name: ‘Successor: Semesters (from Semesters) (from Predecessor - Internships)’

And finally, we set up the automation to trigger whenever ‘Successor: Semesters (from Semesters) (from Predecessor - Internships)’ updates, and its action will be to update the triggering record by pasting the new ‘Successor: Semesters (from Semesters) (from Predecessor - Internships)’ value into the ‘Semesters’ field

(I also put in a conditional to only run it when the field is populated, doesn’t need to be there but keeps the record history cleaner)

Let me know if you have any issues setting it up and I’ll do my best to help!  I also do free half hour calls too and so you can grab a time here if you'd like to do a screenshare and do it together!