Apply Formula to Entire Column

edited 12/09/19 in Formulas and Functions

I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to be more automated. Is there any functionality in Smartsheet that I'm missing that could accomplish this for me? Below is the formula I'm using, if that helps at all.

=$[Job Number]$1 + "-TRANS-00" + [Submittal Number (Sequential)]10 + "_r" + Revision10 + "_" + [Submittal Friendly Name]10

Submittal Document Name Sheet & Formula_20191010.png


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try deleting all of the empty rows from the bottom of the sheet then save. Once you refresh the sheet there will be another 10 blank rows at the bottom.


    I am thinking that maybe you are entering data into blank rows that were previously used. 


    The 10 blank rows that were added during the above steps will be unused.


    As long as the two rows directly above the row you are entering data into have the formula in them, it should auto-populate into the next row down once you enter data into the Primary Column.

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!