Share via

Formula Columns in Microsoft Lists

Anonymous
2024-04-12T08:31:17+00:00

Why does my microsoft list calculated field not auto update?

I have to go to list settings to save it again and refresh before it calculates

I have created a column with the formula is = (RENEWAL DATE) - TODAY()

(RENEWAL DATE) is with reference to another column.

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-12T12:34:16+00:00

    Dear User,

    Good day!!

    Apologies for the inconvenience caused and please don’t worry, let’s work together on your concern and move towards a resolution path.

    I understand your concern and I noticed you are having the problem with the Calculated column using TODAY() function, so I have tested with my old lists having the Calculated column using TODAY() function, where we noticed the TODAY() function is not updating automatically and we need to edit the item to get the value updated.

    Note: I have noticed the same behavior with the List in the SharePoint Online as well.

    To my knowledge, the behavior is not an expected and I believe the problem should be further investigated by the related development team via collecting HAR logs because there is not any related service incident reported at the Microsoft Service Health dashboard.

    I do feel regret for not resolving the problem and redirecting you to the related development team but the fix to your concern can be find out through the HAR logs and suggest you raise a support ticket from the Office 365 admin center, where the related team will investigate the problem further by collecting the HAR logs.

    Reference: Get support - Microsoft 365 admin | Microsoft Learn

    Note: To create a support ticket, you need to have admin privileges and if you aren’t admin of your Office 365 organization, please contact the admin of creating a new ticket. How do I find my Microsoft 365 admin? - Microsoft SupportSupport

    If there is any misunderstanding from our end, we sincerely apologize and request you to share the more detailed information which will help us to better understand and guide you further.

    Appreciate your patience and understanding. Have a great day!!

    Best Regards,

    Sophia

    Was this answer helpful?

    0 comments