Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

Dynamic line numbering formula does not reference new row after adding a row in the table

Hello Experts,
Modify formula, col B, to refer to current row when a row is added to the table. The formulas in column B operate correctly until a row is added to the table using [Tab] or typing in the row below the bottom table row.  To correct the error, the formula in col B must be copied from a properly-referencing formula two rows above.  

Could a function using INDIRECT(row)-1 or similar approach work? Tried deleting the formulas, e.g.,
Col B problem formulas:
=IF([@[Action Items]]<>"",COUNTA(F$3:F15) & ".","")  <--Note there are double ending brackets  
Tried retyping them to have the same function construct as those in
col D which operate correctly after a new row is added:
=IF([@№]<>"",$H$1&"Ÿ.","")   <--Note there are single ending brackets in the OK Col D formulas.
File attached...
Thanks in advance
Berry
Action-Plan.xlsx
0
Berry Metzger
Asked:
Berry Metzger
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=IF([@[Action Items]]<>"";COUNTA(INDIRECT("F$3:F"&ROW(B3)) )& ".";"")

Regards
0
 
Berry MetzgerLean process improvement consultantAuthor Commented:
Great!  This solution works.  
Thanks a lot
Berry
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now