How to integrate the top rows from new form entries into the COUNIF formula?

Options

I am trying to lock the first row in my countif formula, but as the form gets new entries and the rows are added to the top, my countif formula changes does not capture the first row.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!