Applying a formula for the whole column

Thu Nghiem

Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not being applied. I have a suspicion that when I drag down my formula to all cells in the column, it is telling SmartSheet that the subsequent blank row (at the moment) is an actual entry b/c of the formula drag, therefore, the new entry from the form is being added after the last row I ended my formula dragging to. Any help would be great appreciated! And hope this makes sense!

AravindGP

Hi there.

All you have to do is right click on a cell where you have the formula and click on "Convert to Column Formula".

AravindGP

Hi there.

All you have to do is right click on a cell where you have the formula and click on "Convert to Column Formula".

Thu Nghiem

Oh my goodness!! It was right in front of my eyes! Thank you SO much!!