Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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