question

FrankMoleni-3217 avatar image
0 Votes"
FrankMoleni-3217 asked JessieYuan-MSFT edited

Calculated Column Not Updating

I created a calculated column based on a [Start Date] column and Today's date, it works alright, but it stops automatically updating the contents of the cell as time passes, only after I edit the a row does it make the update. The formula is as below: =1+ROUND((TODAY()-[Start Date]),0)&" days"

office-excel-itpro
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sounds like you're using Excel functions/formula to do the same. In case if you're using Graph API let me know. So that i can engage right teams to assist.

1 Vote 1 ·

@FrankMoleni-3217
Please check Lz-3068' reply.
Any updates, please let us know.

1 Vote 1 ·

@erinding-msft
Thank you
I have made a comment on his response, you may see it.

0 Votes 0 ·

1 Answer

Lz-3068 avatar image
0 Votes"
Lz-3068 answered Lz-3068 commented

Hi @FrankMoleni-3217

(Next time please indicate the product in use :)

Only thing I can think of regarding your issue: make sure Power Pivot Calculation Options is set to Automatic

76785-demo.png



demo.png (59.2 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Lz-3068 thank you so much :) this is helpful

As to the program I am using, its Microsoft SharePoint Lists

0 Votes 0 ·
Lz-3068 avatar image Lz-3068 FrankMoleni-3217 ·

Hi @FrankMoleni-3217. Glad I could help a bit (I didn't know Shareppoint Lists have calc. columns as I never used that product) & Thanks for posting back

0 Votes 0 ·