Formula Autofill not Working

System

This discussion was created from comments split from: Automatically add formula to new rows.

Fletcher Boll

I am having the same problem, however, my trouble is happening with newly added rows in parent sections. It is a construction task list and every project is different. I'm seeing that when I add a new row to bedroom 1, I have to drag fill all formulas across the project.

Also, there a few columns that I need to autofill the same info because we assign to contracts row by row. These are filled to reflect summary info ( =description1) and I can drag fill because it will fill the next line with =description 2. I can't copy paste the 3 together because it does the same thing, so I have to do one by one and it's very annoying.

Screen Shot 2020-02-05 at 7.31.40 PM.png

Screen Shot 2020-02-05 at 7.34.39 PM.png

Andrée Starå

Hi Fletcher,

First, make sure that the below conditions are met.

If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.

Conditions That Trigger Formula Autofill

You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

• Directly between two others that contain the same formula in adjacent cells.
• At the topmost of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• At the bottommost of the sheet if it’s below two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formulas.

More info: 

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

Were all conditions met, or was that the issue?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Alan Williams

I have either the same problem or a similar problem. I have a sheet with several formulas in any given row, but two formulas don't copy while all the others do. I can see no difference between formulas from one column to the next. They meet the criteria above (the row has to, or else the other formulas wouldn't populate, either). I have to keep dragging down to copy rows. Can someone help me troubleshoot this?

Andrée Starå

Hi @Alan Williams

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Blake Neyland

I am also having this issue. It seems the conditions are met (see formula in screenshot 1). This formula is in every cell of the column, but when I add a new column the formula is not copied (see screenshot 2).

Screenshot 1.png

screenshot 2.png

Any help is much appreciated.