Make the timestamp to not change based on certain field

Hi there, I’m trying to make an app that works similar to a count sheet. In this app, there are 2 count field (count 1 and count 2) and 2 timestamps ( timestamp 1 and timestamp 2). If the counter has to recount, they have to fill the value at count 2 field and the time recorded have to be at timestamp 2 field. The problem that I am facing right now is that when I refresh the page, the time for timestamp 1 also changes. Is there a way for it to not change?

Instead of using appformula for your timestamp, use column type as ChangeTimestamp.

1 Like

For reference: