JMcI✭✭

Great!

Looks like you have slanted or "smart quotes" round your ”Active-NonCompliant”, replace them with what you have on "Y" and "N" =IF(AND([Spend 2022]@row = 0, [Spend 2023]@row = 0, [Compliance Status]@row <> "Active-NonCompliant"), "Y", "N")

Do you have field logic applied? If so ensure it is also set to " Show the following fields as required" OR "Show the following fields as editable"