How to avoid #REF errors when referenced cell is deleted


I am trying to make a Sheet Summary field that always references the first row in the column (aka ColumnName1). But if I make that reference and then the row is deleted, the reference breaks and gives a #REF error. How can I make a formula that will always reference the first row in the column regardless of what happens in the sheet?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!