How to update info from multiple sheets to one master log?
Good evening. I am working on setting up Smartsheet to track engineering information for my company. Each branch has it's own sheet and one person responsible for logging data into this sheet. That data is then copied to a "Master" sheet for company-wide comparison.
Most of the information is known at the time of input, but some has to be updated later. I have automation set up to copy new rows to the Master, but I do not have a way to copy the updates to the master log other than manually finding each blank space and referencing the correct cell on the correct sheet to get that information once it updates.
Is there a simpler way to update this information?
I have attached a screenshot. Job number and name is unique and will be known at the time the data is initially input and copied to the master, but other information may not be known right away as seen by the blanks.
Help Article Resources
Check out the Formula Handbook template!