Dear team, Here is the formula which i paste ...

[Etwo_Cargo]

Dear team, Here is the formula which i paste it in initial value. The idea is; update the duration as day for every new day. But value is still as freeze. What could be the reason? The formula was in app formula previously. Result was same. I want to have update duration day and see how many day goods still in my warehouse. Is my way wrong?

=HOUR(TODAY()-[DATE])/24

[Aleksi_Alkio]

Instead of normal column, you should use either virtual column or Sheetformula.

[Etwo_Cargo]

@Aleksi_Alkio

Dear Aleksi thanks. It is not possible to set that virtual column in column order (view option). Am i right?

[Aleksi_Alkio]

Not correct. You can specify the column order with the virtual column as well.