Populating Sheet Column Content from Report

Ernest.Schipman

We are using a unified Asset Tracking sheet in smartsheets for multiple types of Equipment (i.e. Phone, Computer, Printer, etc...). This sheet has basic Asset Tracking information in it but we need to gather additional equipment specific to each type of equipment as well. We could create a column for each in the Unified Asset Inventory sheet but it would become very busy very fast. Is there a way to create new sheets in which the data specified (i.e. computers only) are automatically populated and in which we can add additional columns to populate specific infomation for that piece of equipment?

Andrée Starå

Hi Ernest,

One way to do it could be thru cell linking to another sheet and add the columns needed. You could then filter the specific asset types.

Would that work?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Keep in mind that cell linking will not create a NEW row. That would have to be done manually.

 

Another option would be to do it in reverse. Create the specific sheets, then use a report to gather all of the general info across all of them.