Populating Sheet Column Content from Report


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!