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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…