Yeah, it's so strange. Format is set to text. It's just a lookup to another sheet. Exact same formula as the row that works but adjusted for different reference.
The act of editing it in the formula field somehow seems to change it from a formula to text. I can enter into a row with functioning formula in a cell, and any edit, even just deleting and retyping a ")" at the end of formula somehow stops the formula from working when I stop editing.
LibreOffice (npub1tgg…qwzh)
