Initial value to be the previous value of adjacent column

[Steven_Velletri]

I want the initial value of a form value to equal the previous value of the adjacent column.
The formula would look like this R[-1]C[1] but this can’t be entered for initial value. How do i do this?

I could create another column which has this value but it seems overkill.

Cheers
Steven