Creating a formula that references a static cell?

Jennifer Whitlock
Jennifer Whitlock ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions



I have a form that is submitted to one of my sheets daily. Currently, new entries populate at the top of the sheet. I am using a formula that always needs to reference the top row, or newest entry. Is there a way to accomplish this? Currently, if a new entry is submitted, the formula changes to tracking row 2 instead.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!