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


    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!