Automatically updating a super sheet?


I am new to smart sheets and have been tasked with creating a master schedule for our teams. I am working with two different teams on a project and each team has its own schedule. Is there a way that I can set up the team schedules to automatically feed into a super sheet?

Ideally, I would like them to identify if an item on the schedule is a key event and then have all of the key events feed into the master schedule. I've tried to hyperlink cells but I don't want to have to constantly update the super sheet with hyperlinks.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!