Reference Text from one cell to another cell, using a formula

I have text in a column called “Task Name”. I want to reference the content in cell 1 to cell 3. What should that formula look look.. I have tried =[Task Name]1 but it does not work.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!