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.
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.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
