How can I create a link in multiple cells simultaneously?

gjohnson.pcpro
gjohnson.pcpro ✭✭✭
edited 08/30/22 in Formulas and Functions

Hello,

I want to link a cell in one sheet to multiple cells in another sheet. The source cell contains a date, and I need that date to be linked to multiple cells (all in the same column) in another sheet.

I've tried highlighting multiple cells in the destination sheet and using Paste Special -> Links to copied cells, but that only creates a link in the very first cell. I've also tried highlighting multiple cells in the destination sheet -> right click -> Link from cell in other sheet...but that produces the same result. It only populates the first cell.

How can I go about creating links in multiple cells simultaneously? As it stands, I have 190+ rows that require this same link, and I would prefer not to perform this action 190 times.

Thank you!



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!