0

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

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 '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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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