How to stop dates/times from updating when synchronising the app?

[JackReman]

Good Morning,

I have a virtual column in my app that contains a date. This date updates to the NOW() date, based on the status of the data in another column.

For example, I have a 'Yes/No' button and when the user presses 'No', the date in the virtual column needs to update to the NOW() date. Otherwise the column is hidden from view.

I have this function working correctly using the following formula;

IFS([État du Remboursement] = "Fermé", NOW())

However, every time the App is synchronised and the condition is met, the date NOW() is being updated.

How can I have this function work one time, and then not update the date NOW() when the app is synchronised?

Thanks in advance,

Jack