I would like a row on my list view to show red if a date is one month away.

Very new to JSON, this is what I've started with:
I think where I have typed ONE MONTH AWAY I need a calculation but just not sure I'm even on the right track.

  "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
  "additionalRowClass": "=if([$1CETVExpiryDate] <= @[ONE MONTH AWAY], 'sp-field-severity--severeWarning', '')"

Your Answer

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

Browse other questions tagged or ask your own question.