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

(Etwo Cargo) #1

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) #2

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

(Etwo Cargo) #3

@Aleksi_Alkio

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

(Aleksi Alkio) #4

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