keep a copy of the first value written to a cell.
I want to copy and record the first cell value even if the first cell value changes.
I am writing a program to generate PO#'s sequentially only on certain lines, so I can skip category headings. I have this part down well. See the formula here: =IF(Bucket@row <> "", "A****" + "00" + IFERROR(MATCH([Row ID]@row, COLLECT([Row ID]:[Row ID], Bucket:Bucket, <>""), 0), ""), "")
So, if the cell is populated under "Bucket", it automatically generated a PO# A****001 in the first row, and counts sequentially for each row in which something is put under "Bucket".
The problem is that the value of the PO# is dynamic, so it can be changed after it is created, if a row were to be inserted and its associated "Bucket" cell contains a value, everything after that increases.
I'm hoping to copy the value of PO# into another cell called "Stagnant PO#" in the same sheet and make its value stagnant or locked so that if the source PO# changes, the copied cell does not.
Can someone help me with this?