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?

also read: https://sharepoint.stackexchange.com/questions/151144/how-to-use-today-and-me-in-calculated-column/151336#151336 — Danny '365CSI' Engelman, Sep 25 '17 at 15:48
I use today() as sharepoint function not column and I compare that date with a column called [fieldone] — Ledwing, Sep 25 '17 at 15:45

score 1 · Answer 1 · answered Sep 25 '17 at 17:47

1

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

Add New Item.
Update Existing item.
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

answered Sep 25 '17 at 17:47

Mohamed El-Qassas MVP

45,382
9
53
96

and with javascript I cant do it? I mean something like my new question – Ledwing Sep 25 '17 at 17:52
The above-mentioned is the available solution without code if you need with coding you should try JSLink! – Mohamed El-Qassas MVP Sep 25 '17 at 17:59
Or can you show me how can I do workflow step by step in sharepoint online please? – Ledwing Sep 25 '17 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! – Mohamed El-Qassas MVP Sep 25 '17 at 18:05
but without using designer... I mean only using sharepoint online – Ledwing Sep 25 '17 at 18:05
No, you can't, there is no OOTB workflow to achieve this, tell me What's your issue to use SPD? – Mohamed El-Qassas MVP Sep 25 '17 at 18:07

Update date calculated column depending of date

1 Answers1