- March 29, 2018 at 20:04 #16854
I’m wondering if there is a way to have a formula increment itself when copying and pasting the formula into the next cell. Example: Cell D2 has formula =SUM(B2+C2) and I want cell D3 to automatically increment to =SUM(B3+C3) without having to manually edit the cell D3 to reflect =SUM(B3+C3)… As of now when I copy and paste a formula to the cell or cells below, I have to go into each cell and edit each cell formula to reflect the row number(s) that I am on… Maybe I’m missing something but I see no other way to do it other than manually… There are times when I want to enter 20 to 30 records at a time and then I have to go to each cell(s) on each row and manually edit each formula… Thanks in advance for any help in this matter. If this is something that only comes with the PRO version, then I will purchase it…May 16, 2018 at 14:11 #17580
Though you have already contacted us via internal support, I’d like to reply, that there is an ability to implement it via dragging, not copying. Hope this variant will fit your needs too!May 16, 2018 at 17:35 #17627
I can drag formula filled rows down to an empty row but the formulas do not increment… Example: In one of the cells that is dragged down to row 21 from row 20 will still have row 20 formulas… Instead of row 21 reflecting =SUM(D21*F21) it still reflects =SUM(D20*F20)… Any ideas as to why it won’t increment?
- You must be logged in to reply to this topic.