I am new to JSON but I figured that is what I need to use. I have tried to look on different forums and guide but can't find out how I can accomplice what I am after.
I have a SharePoint list with 4 columns StartDate, ApplyFrom, EndDate. I want to evaluate all this columns in to a separate column named Progress. Where if any of the dates in the 3 columns are today -10 days will give Green color, and if the today -3 days Yellow, and if today orange, If today +1 day red. Once it passed today +5 days it should have no color.
Maybe this isn't possible and I am asking to much.