Is there a way to reference an entire row in a formula? I'm trying to count check boxes across an entire row, but don't want to re-write my formula if I add a column.
Thank you!
I found a way to do it, I just referenced a range of cells in the row. I just have to make sure I insert rows to the right of my last column.
Happy to hear you figured it out! When you select a row range in a formula, inserting a column within that range will include the new column in the formula. But, inserting a column outside of the range will not include the new column in the formula.
