Oct 25 2022 06:40 AM - edited Oct 25 2022 07:12 AM
I am looking for a JSON code that changes de color of the ROW to red if it is 200 days after the date of a column.
So the column says 10/12/2022 (dd/mm/jjjj)
And if it today 200 days after that date, the color of the whole row must be read.
I have searched a lot but cannot find some based on the date of a column.
Please is there somebody who can help me?
Rense
Oct 25 2022 07:45 AM
Oct 26 2022 12:49 AM
Solution@Rense620 Use JSON view formatting code like below:
{
"schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if(addDays([$Modified], 190) < @now && addDays([$Modified], 200) > @now, 'sp-field-severity--warning', if(addDays([$Modified], 200) < @now, 'sp-field-severity--blocked', ''))"
}
Documentation: view-list-formatting
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.
Oct 26 2022 04:53 AM - edited Oct 26 2022 04:53 AM
That did the trick!
First I made a little typo... :)
Thank you very much for you help!