Calculated Column Not Updating

Frank Moleni 21

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"

Deva-MSFT 2,256 Reputation points Microsoft Employee

2021-03-11T08:02:22.207+00:00

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.
Erin Ding-MSFT 4,456 Reputation points

2021-03-12T09:48:11.79+00:00

@Frank Moleni
Please check Lz-3068' reply.
Any updates, please let us know.
Frank Moleni 21 Reputation points

2021-03-13T17:07:40.357+00:00

@Erin Ding-MSFT
Thank you
I have made a comment on his response, you may see it.

Accepted answer

Lz._ 8,991 Reputation points

2021-03-11T13:25:59.09+00:00

Hi @Frank Moleni

(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
Please sign in to rate this answer.
Frank Moleni 21 Reputation points

2021-03-13T17:02:50.447+00:00

Hi @Lz._ thank you so much :) this is helpful

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

Lz._ 8,991 Reputation points

2021-03-14T03:48:21.85+00:00

Hi @Frank Moleni . 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
Sign in to comment

Calculated Column Not Updating

0 additional answers