How can I add an individual cell link within a column with a formula applied?

Options

I'm working with a PMO Template which includes an Intake Form/Sheet. In the Intake Sheet I have some existing rows corresponding to several existing project folders, hence individual Project Plans. We have a column for Start Date which was originally using a Cell Link to populate the Start Date value from the corresponding Project's Metadata. But I had to create the cell link every time a new project was created. So, I've created a column formula using a reference to populate the Start Date from the Project Metadata on any new rows moving forward. The column formula's reference points to the Project Metadata sheet within the Project Template folder so when the Project Template is used to create a new project the references will automatically update with the row's corresponding Project Metadata sheet. Here's the problem. My existing rows are no longer cell linked to their corresponding Projects because I've applied the formula to the entire column. I need to overwrite the Start Date for each existing row to cell link from the corresponding Project Metadata without breaking the column formula.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!