Microsoft List formula is not working

Hi Imi_Jay ,

instead of using a calculated column you can also use JSON list formatting to achieve this effect.
That will recalculate automatically.

I translated your formula into this JSON (I hope i got the logic right)

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if([$DueDate]=='Missing info','Missing info',if(((Number([$DueDate])<=Number(@now)) && (toString([$ResultOutcome]) == '') && (toString([$DateResultMarked]) == '')) || ((Number([$DueDate])<=Number(@now)) && [$Require2ndAttempt] && (toString([$ResultOutcome]) == '') && (toString([$DateResubmissionPassed]) == '')),'OVERDUE',''))"
}

 
Just select your column and then select "Column Settings" and then "Format this column"

Switch to "Advanced Mode " at the bottom of the new dialog

Now paste the JSON formatting into the editor and save

Best Regards,
Sven

Imi_Jay What is the data type of [Due date] column, single line of text or date & time?

Also, it is default behavior of SharePoint calculated formulas that calculated column values are calculated only when: 

• A new item is created
• An existing item is updated
• Calculated column formula is updated

Check my answer given here for more information: Impact on Performance of Calculated Columns 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Hi Imi_Jay 

The issue you're facing with the calculated formula in Microsoft List could be related to the automatic recalculation behavior of the formula. Unlike Excel, which recalculates formulas automatically, Microsoft Lists might require a manual trigger for the formula to update and display the correct result.

When you make edits to a record in Microsoft List, it triggers the recalculation of the formulas, which is why you see the correct result after performing some edits. However, for existing records that haven't been modified, the formula might not update automatically.

To resolve this issue, you can try the following steps:

1. Verify the list settings: Ensure that the "Automatic" recalculation mode is enabled for your list. You can check this by going to the List settings and navigating to the "Advanced settings" section.

2. Manual recalculation: After making changes to your list data, you can manually trigger the recalculation of formulas by using the "Calculate" or "Refresh" option. Look for these options in the toolbar or menu of your Microsoft List application.

3. Check for dependencies: If your formula refers to values from other columns or records, ensure that those dependencies are updated correctly. If any referenced values are not refreshed, it could affect the outcome of your formula.

4. Reevaluate your formula: Review your formula for any potential issues or logical errors. Consider simplifying or restructuring it to ensure optimal performance and accurate results.

If the problem persists despite trying these steps, it might be a limitation or bug in the specific version or implementation of Microsoft List you are using. In that case, reaching out to Microsoft support or the relevant community forums for further assistance would be advisable.

I hope this helps! Let me know if you have any further questions.