Formula to automatically pull cell data from one column of a source Smartsheet to another

System · 09/11/24

This discussion was created from comments split from:

Automatically copy cells from one sheet to another

.

NicoLHC · 09/13/24

@Rick Byers maybe you can try index match or collect ?

Genevieve P. · 09/16/24

I agree with @NicoLHC! Here's a Help Article that goes through how to structure an INDEX(MATCH type of formula:

NicoLHC · 09/16/24

@Rick Byers if you need more help feel free to share or invite me to the sheet . nico.roepnack@lighthouseconsultings.com

Answers