Nested formula not working

I have been using the below formula in a SharePoint Column, to find the most recent year column that 'comprehensive' is mentioned and have that year value returned to the calculated column - it is suddenly not working - or if I reset it, it works for less than a minute and then converts to only one year '2024'.  If I reduce the number of years/columns in the formula to only two it works properly and the results stay.  Any ideas what the problem is?

=IF(NOT(ISERROR(FIND("comprehensive",[2024]))),"2024",IF(NOT(ISERROR(FIND("comprehensive",[2023]))),"2023",IF(NOT(ISERROR(FIND("comprehensive",[2022]))),"2022",IF(NOT(ISERROR(FIND("comprehensive",[2021]))),"2021","No Review"))))

Thanks in advance and I am not an expert in anything IT but I am trying to use this to track work in my team.

Cheers

Karen