Best Practice for connecting sheets
Hi everyone. Can you help me with some ideas on how to best connect sheets when using a basic Smartsheet plan? I have a Master Sheet that houses all properties. But then on various sheets, I'd like to list details. For example, the master sheet would feed information into a sheet that tracks lease information. Another sheet would track tax information and another sheet would track loans.
My initial thought is that when a new line is added to the master sheet, the data can copy over to these various sheets where we can start collecting data.
Does anyone else have other ideas? Thanks in advance for your assistance!