Applying a formula for the whole column

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!


Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    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".



    Reach out for any help on licenses, configuration, or training


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!