using a form to input new data means my formula no longer works.

edited 12/09/19 in Formulas and Functions



I am using a lookup formula to find prices for specific things. once a form is used and new information is inputted into the top row the formula says unparseable and the [column name]1 changes to [column name]2. I would like to stay as [column name]1 even when new information is put onto the sheet.


Please can someone tell me a way to achieve this?


Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!