Forum Discussion
Solved
NOW() - calculated default value not working
quite express example: a freshly created list "X", with a numeric column "zz" whose default value is calculated, =NOW() zz column: Now open the list and add 2 or more items during t...
SOLVED, formula for this case must be "=VALUE(now())", not only "=now()"
Hi Webb, no, it isn't...
From what I recall you always use default value and use [Today] in there. Calculated columns are usually values based on other columns / formula so it seems like it’s doing what it should be doing.
not sure if I understood fine, this is not a calculated column but number column (the Now() is in the formula for its default value)... we need to reach to the seconds