I have calculated in a list column who compare dates and return yes or no

Formula: =TODAY()<[Fieldone]

So it returns yes or no correctly, problem is when conditioning of date changes because date for example

If today is 24/08/2017 and Fieldone is 25/08/2017 it returns Yes, but if today is 24/08/2017 and Fieldone is 23/08/2017 it need to return Yes, but when date pass it don´t update register automatically. How can I update that value automatically?


1 Answer 1


It's a normal behavior, The calculated column formula is only calculated/updated In the following cases:

  1. Add New Item.
  2. Update Existing item.
  3. Update the calculated column itself in the list setting!

So, unfortunately, you can't update the calculated column value automatically.

For more details check The supported and unsupported fields in SharePoint calculated column formula

The available workaround in SharePoint online is

Creating a workflow which updates the list items daily via Retention Policy

  • and with javascript I cant do it? I mean something like my new question
    – Ledwing
    Sep 25, 2017 at 17:52
  • The above-mentioned is the available solution without code if you need with coding you should try JSLink! Sep 25, 2017 at 17:59
  • Or can you show me how can I do workflow step by step in sharepoint online please?
    – Ledwing
    Sep 25, 2017 at 18:00
  • Using a SharePoint designer, create a simple workflow to update the column value like title value with itself then create a retention policy to start this workflow as mentioned in the above link to run it periodically! Sep 25, 2017 at 18:05
  • but without using designer... I mean only using sharepoint online
    – Ledwing
    Sep 25, 2017 at 18:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.