Microsoft List formula is not working

Hi all, I am encountering a problem in a calculated formula in the Microsoft List. Scenario- Based on different values in different columns , I need a record to appear as "Overdue" Formula u...

Lists

microsoft lists

SharePoint Online

SvenSieverding

Bronze Contributor

Jul 18, 2023

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

Brass Contributor

Jul 20, 2023

Hi Sven,

Thanks very much.I will try this.I don't know JSON at all.Hence trying to find a solution that would go with A2 style formulas. I will try this. The logic should be fine.

Thanks,
Imalka Jayalath

Forum Discussion

Microsoft List formula is not working

Resources