Apply Formula to Entire Column

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

Find more posts tagged with

Construction

Formulas

Solution Center

Product Development

Project Management

Enhancement Request

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)