SOLVED

NOW() - calculated default value not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2513433%22%20slang%3D%22en-US%22%3ENOW()%20-%20calculated%20default%20value%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513433%22%20slang%3D%22en-US%22%3E%3CP%3Equite%20express%20example%3A%3C%2FP%3E%3CP%3Ea%20freshly%20created%20list%20%22X%22%2C%20with%20a%20numeric%20column%20%22zz%22%20whose%20default%20value%20is%20calculated%2C%20%3D%3CSTRONG%3ENOW()%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msauaf_0-1625320312636.png%22%20style%3D%22width%3A%20231px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293273i29F1202A013D3BA4%2Fimage-dimensions%2F231x147%3Fv%3Dv2%22%20width%3D%22231%22%20height%3D%22147%22%20role%3D%22button%22%20title%3D%22msauaf_0-1625320312636.png%22%20alt%3D%22msauaf_0-1625320312636.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ezz%20column%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msauaf_1-1625320386045.png%22%20style%3D%22width%3A%20312px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293274iA49903261A5CA905%2Fimage-dimensions%2F312x503%3Fv%3Dv2%22%20width%3D%22312%22%20height%3D%22503%22%20role%3D%22button%22%20title%3D%22msauaf_1-1625320386045.png%22%20alt%3D%22msauaf_1-1625320386045.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20open%20the%20list%20and%20add%202%20or%20more%20items%20during%20the%20next%205%20-%2010%20seconds%20(or%20all%20day%20long...%20ALL%20of%20them%20will%20show%20up%20with%20a%20SAME%20value%3A%20the%20one%20of%20when%20you%20have%20arrived%20at%20%2F%20opened%20the%20list.%20So%2C%26nbsp%3B%3CU%3Enot%3C%2FU%3E%26nbsp%3Bwhen%20you%20actually%20have%26nbsp%3B%3CSTRONG%3E%3CEM%3Eadded%3C%2FEM%3E%3C%2FSTRONG%3E%20them%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msauaf_2-1625320573789.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293275iDEE9288E4BAED7CF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22msauaf_2-1625320573789.png%22%20alt%3D%22msauaf_2-1625320573789.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20more%20people%20been%20experiencing%20this%3F%20it%20seems%20it%20begun%20last%20week%2C%20along%20with%20the%20%22double%22%20click%20now%20needed%20to%20add%20an%20item%20when%20you%20have%20just%20opened%20a%26nbsp%3Blist%20%3A%5C%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2513433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2513566%22%20slang%3D%22en-US%22%3ERe%3A%20NOW()%20-%20calculated%20default%20value%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513566%22%20slang%3D%22en-US%22%3EWhen%20you%20open%20the%20item%20is%20the%20value%20correct%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2524592%22%20slang%3D%22en-US%22%3ERe%3A%20NOW()%20-%20calculated%20default%20value%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2524592%22%20slang%3D%22en-US%22%3EHi%20Webb%2C%20no%2C%20it%20isn't...%3C%2FLINGO-BODY%3E
Contributor

quite express example:

a freshly created list "X", with a numeric column "zz" whose default value is calculated, =NOW()

msauaf_0-1625320312636.png

zz column:

msauaf_1-1625320386045.png

 

Now open the list and add 2 or more items during the next 5 - 10 seconds (or all day long... ALL of them will show up with a SAME value: the one of when you have arrived at / opened the list. So, not when you actually have added them:

 

msauaf_2-1625320573789.png

 

 

Have more people been experiencing this? it seems it begun last week, along with the "double" click now needed to add an item when you have just opened a list :\

 

6 Replies
When you open the item is the value correct?
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.

An update: I've just tried another approach. I've created a "tt" number column whose default value is =TIMEVALUE(NOW()). But whenever I add a new item, the related field shows up as BLANK :\

msauaf_0-1625686581631.png

 

msauaf_1-1625686629347.png

 

 

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

 

msauaf_0-1625687801403.png

 

best response confirmed by msauaf (Contributor)
Solution

SOLVED, formula for this case must be "=VALUE(now())", not only "=now()"