1

We have a Custom List in SP Online which pertains to parts needing to be inspected. Our list has the following fields:

  • LAST-INSP: a manually entered date showing when the part was last inspected.
  • FREQ-IN-DAYS: frequency of inspection, manually entered by the Quality staff.
  • NEXT-INSP: a calcuated field as: =[LAST-INSP]+[FREQ-IN-DAYS]
  • INSP-DUE: a calculated field as: =[NEXT-INSP]<=TODAY()

Normally this works as expected, but sometimes we see a "glitch" where the Inspection Due field does not change. For example, today I looked and found this

enter image description here

The highlighted row SHOULD have the INSP-DUE field set to YES because the Next Inspection date is equal to today, but it's not updating properly.

Is there a known issue with calculated fields? Is there something I'm missing in my formula? Is the date field using local vs. UTC date/time? Is there a parameter in SP Online for calculated fields that I need to check?

Any help would be greatly appreciated.

gpence

Mohamed El-Qassas MVP
  • 45,382
  • 9
  • 53
  • 96
gpence
  • 295
  • 4
  • 14

1 Answers1

3

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!

Check also, The Supported and Unsupported Columns In SharePoint Calculated fields

Mohamed El-Qassas MVP
  • 45,382
  • 9
  • 53
  • 96
  • Thank you, Mohamed. Let me also ask this for clarification purposes: When you say "Add a New Item" or "Update Existing Item" -- are only those records recalculated, or are all rows in the list recalculated? Also, is it possible to create a Flow to force the column to update all records on a daily basis? – gpence Dec 17 '18 at 21:55
  • Only this record will be recalculated, flow and sharepoint designer workflow is only applied on the current row, not a column. – Mohamed El-Qassas MVP Dec 18 '18 at 20:22
  • For more background info see: https://sharepoint.stackexchange.com/questions/151144/how-to-use-today-and-me-in-calculated-column/151336#151336 – Danny '365CSI' Engelman May 21 '19 at 09:29