Timeline for Inserting a row in Google Sheets does not copy the formula present in other rows
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 31, 2018 at 6:19 | vote | accept | Varun Bhatia | ||
| Oct 22, 2018 at 22:19 | comment | added | Erik Tyler | Additional thought until I can see your sheet: if your data rows are being filled automatically, say with data from Google Forms, then you can't use an array on that sheet. Again, an array needs an empty range below it to fill. There are standard practices for manipulating data that comes into Sheets from an outside source, the first of which is to set up a second sheet to process the raw data the way you want to use it. That is where the array formula would be used. | |
| Oct 22, 2018 at 22:16 | comment | added | Erik Tyler | Varun, an array formula doesn't just take up one cell; it takes up however many rows you tell it to. If you placed this formula into cell F2 but you have data in cell F4, it won't work because the array formula as written applies to "every row in column M." And if you have data in cell F4, then the most an array could expand if placed in F2 would be two cells: F2 and F3. Then I would ask, why do you need an array formula for two cells? Please post a version of your sheet along with a description of what you want the formula to do; then people here can see what you see and better direct you. | |
| Oct 22, 2018 at 5:55 | comment | added | Varun Bhatia | it didn't work.. more over, i am getting an error that "Array result was not expanded because it would overwrite data in F4" | |
| Oct 21, 2018 at 15:03 | history | answered | Erik Tyler | CC BY-SA 4.0 |