Using a sheet as a master for other sheets
Hello, we have a 'Current Employees' Smartsheet which lists all employees with certain information such as Start Date, Contact Details, etc. If an employee finishes we enter a Finish Date and this then automates them (that row) being moved to another sheet.
What we are trying to achieve is to use the above 'Current Employees' sheet as a master document or database for other sheets where we need to show a list of our current employees, e.g. training records. We don't need all the info from the main sheet but we do need to be able to add columns in so a Report won't work in this instance. I don't think cell linking will work either as it would mean having to relink all sheets if someone starts or finishes. Does anyone have an idea for how to achieve this?