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.
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
Hello Community, I need to create a report that shows capacity by month. My sheet tracks resource allocation on projects with resource start and end dates. (We can't afford the Resource Management module so we're doing it in Core SS). I've been asked to do a "heat map" of sorts where each column is a month. For each row…
