Column Formula Not Filling All Rows
I have a column formula that isn't filling all rows. I have a row id with auto numbering and it's only going to 4 rows. I need it to fill in the whole sheet so that my index match formulas can look up if another row is created in another sheet. I'd like to get the auto numbering column to continue filling in the rows for the whole sheet or for a way to pull the row id from the other sheet in (not sure if there's a column formula out there that i can use to pull in each row in a column if the cell isn't blank but I haven't found one yet).
Help Article Resources
Check out the Formula Handbook template!