Dynamic Cell linking empty fields

I'm trying to use cell linking but it won't let me link a cell that doesn't have data in it yet.

My plan is to have it link to a cell that will have data put in it gathered from a form.

The end result is that I'll have two sheets. The first sheet is populated with data gathered from the form, and then the second sheet will have fields linked to the results to display the data differently. The issue is that I can't cell link unless there is data in there...So maybe cell linking isn't the right thing to use.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!