Referencing column in another sheet from row 2 only

kat_h
kat_h
edited 12/09/19 in Formulas and Functions

I am trying to set up a formula that counts the number of cells containing information in the first column on another sheet. I just don't want it to count the text that is in row 1 (ie I just want it to count from row 2 onwards as I am constantly adding data to column). I don't want the formula to even reference row 1 as it creates a "hover" box that hides other data when viewing the referenced sheet on a display screen.

I have tried just selecting the cells in the column that I want but as data is added to sheet or shifted to other sheets, it is constantly reducing the range that has been selected for the formula requiring constant updating of the formula range.

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!