Linking multiple cells (with a caveat)
Hello Smartsheet Community! I'm trying to link multiple cells at once from the source sheet (the information is in cells across one row. They are not necessarily contiguous, but I could make it that way if necessary, which my example will show, but I would prefer not to do it that way.). To link them into my destination sheet, I need the information to be listed in a column instead of a row (Column B). I know I can link each individual cell separately. Indeed, that is a fix, but it is not time efficient. So, does anyone know how to do this using or not using a contiguous range in the source sheet? Thanks in advance for your help.
EDIT: Realized I posted this in the wrong forum. Will re-post appropriately.
Help Article Resources
Check out the Formula Handbook template!