I have an aging column in SharePoint, that I would like to reflect show RAG (Red, Amber and Green) status based on the amount of days each case has aged.

Aging<15 Green

Aging >=15<30 Amber

Aging >=30 Red

Status can just display words "Green", "Amber" and "Red".

What would be the if statement to achive this?


you can use on SPO formatting columns with JSON, documentation here.


For SPO, as Zdeněk Vinduška mentioned, you can customise SharePoint Online Columns Using JSON – Column Formatter.

For SharePoint On-premise, you can use the methods in below articles:



Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.