Row Id is empty

Hi All,

I’m using row ids to give our projects a code which resets back to 001 each year (20-001, 20-002, 20-003, 21-001, …) but it’s a bit unreliable at the moment because the row id property of certain rows are empty. This means we end up with non-unique project codes and unreliable codes in rows that are made after the broken row. See image below.

What’s really weird… is that when you pull the data in elsewhere using cross-doc, the project codes are correct…

Any thoughts?