Formula renumbers when row added - I don't want it to.
I have a formula that populates the Asset #
=IF(COUNT(ANCESTORS([Deliverables and Tasks]@row)) = 2, (Product@row) + 10 + COUNT(DISTINCT([Asset #]$1:[Asset #]6)), PARENT())
This generates MA100, MA101, etc. where each Ancestor = 2 (basically)
This works fine EXCEPT when rows are added in between tasks. Then it renumbers the following Asset #'s. I want the inserted row to have an asset number to not to change the other asset numbers in rows following.
Any suggestions on how to implement this?
Help Article Resources
Check out the Formula Handbook template!