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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!