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
Instead of normal column, you should use either virtual column or Sheetformula.
Dear Aleksi thanks. It is not possible to set that virtual column in column order (view option). Am i right?
Not correct. You can specify the column order with the virtual column as well.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |