Update date calculated column depending of date

Question

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?

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

• Check the detail steps at Automatically update a column with a type of calculated value in a SharePoint List