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.