The formula I tried but doesn't work quite right is

=IF([@[DMR?]]<>"",2025 & MAX($F1:F1)+1,"")

The idea is to create a unique number that is 1 more than the last number created. I am trying to embed the year to help know what excel database to find information on the unique number as we archive the spreadsheet every year and start fresh. The formula does generate a number but it is always giving me "20251" regardless of the last time the formula resulted in "True". Is what I am trying to do possible with just a formula? Thanks in advance!