I am having a issue with a previously working formula

Hi,

I use Excel primarily on SharePoint to track inspections on a production floor. I have used the same formula for over a year: =IFS(D38=FALSE,"",E38="",NOW(),TRUE,E38).

Essentially, when the field is checked off, it autostamps it with the time and date. (See Picture). Since Friday, however, the time and date defaults to what is shown in the picture.

Troubleshooting I have tried is confirming that all devices using this sheet are time-synced, up to date, and restarted. I have confirmed that the calculation options are set to automatic and that the formatting is correct for both time and date. I have re-typed the formula as well. I am at a loss, as it was a perfectly functional formula up until Friday.

Correct time stamp

Error time stamp