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 have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
Hi, I am trying to get a column that provides the Date (easy with Record a Date) but I need the TIME as well. Most of my tables I just use the right function on the Modified Date because the only thing updating those tables are automations or data imports. But a few tables have automations, data imports, and manual inputs.…
I’m hoping to get a second set of eyes from the community in case I’m missing something obvious or there’s a cleaner pattern I should be using. I’ve used ChatGPT to try and help me group/organize my situation coherently…. Because at this point I feel crazy… I’ve literally worked on this for hours. Environment •Smartsheet…
