Can information be pulled to the primary column of another sheet?
We have a ‘central repository’ Smartsheet which lists all of our clients and pertinent client data. Each client has a unique client ID in the primary column, which is used in “Index/Match” formulas to bring specific client data to other sheets. When we add new clients to the repository, we must also manually add the client ID to all of the individual sheets (primary columns) that use the Index/Match function. Is there any way to automatically pull new client ID to the other sheets? I doubt it but am open for ideas. Thanks!
Help Article Resources
Check out the Formula Handbook template!