I have the following column set up as a primary key for a datamesh. The intention is to copy each row over to a reporting sheet 1 time each month. This formula has not changed, and the records within the "BCA #" have not changed - yet I see to inserts into my reporting sheet from a smartsheet automation with differing PBI_AUDIT output values. I can't make sense of this - it appears as if there may be a bug behind the scenes potentially, as all audit history contradicts this output.
=MONTH(TODAY()) + "-" + YEAR(TODAY()) + "-" + [BCA #]@row + IF((ISBLANK([BCA #]@row)), "-" + [Projects By Initiative]@row, "")
