Other than Initial Value, is there a way to set the value of a column with a formula that is not dynamic?

[Jerry_Hill]

I have several instances where I want to set the value of a column based on another column (trigger value) using a formula; and once that value is set I don’t want it to change. “Initial Value” won’t work because the instance of change does not occur when the record (row) is created. App Formula is dynamic so it will change if the trigger value changes. BTW in each of my cases the value I want to capture is DateTime.

[Suvrutt_Gurjar · Accepted solution]

You may wish to further elaborate on what you mean by

Jerry_Hill:

on another column (trigger value)

Based on your description so far, you may wish to take a look at the change type columns , especially ChangeTimeStamp type column, just in case you have not yet.

Tracking Changes Using "Change" Column Types | AppSheet Help Center

https://www.appsheet.com/samples/Keep-track-of-when-columns-change?appGuidString=8a1572da-c548-418c-...

[Jerry_Hill]

Thanks, that works.

[Marc_Dillon]

Use Initial Value along with a Reset On Edit expression such as:

AND(
ISBLANK( [_THIS] ) ,
[other column] = x
)

[Jerry_Hill]

I tried this approach, but it only sets the DateTime when the record is created. The tip from Suvruff using ChangeTimestamp worked. Thanks, I did learn from your example.

[Marc_Dillon]

You would have needed to use a conditional in the Initial Value as well, like:

IF( [other column] = x , y , “” )