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