Sign in to join the conversation:
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.
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:
More info:
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!
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?
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)
Be safe and have a fantastic week!
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!
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).
Any help is much appreciated.
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
