Hi Guys, i need help in formatting a columns in sharepoint with colour options

Question

Hi Guys, i need help in formatting a columns in sharepoint with colour options

Let say, I have Forecast Begin Date which should show with priority.

If Forecast Begin Date is within 7 days it should show in red colour
If Forecast Begin Date is within 8-15 days it should show in orange colour
If Forecast Begin Date is within 16-30 days it should show in yellow colour
And Forecast Begin Date is more than 30 days it should show in green colour

Also if Forecast Begin Date has crossed it should not have any colour.

Thanks\

Answer 1

@Anonymous

You could use following JSON formatting formula for the Forecast Begin Date column.

{  
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
  "elmType": "div",  
  "txtContent": "@currentField",  
  "style": {  
    "color": "black",  
    "background-color": "=if(@currentField>@now + 2592000000,'green', if((@currentField>=@now + 1382400000) && (@currentField<@now + 2592000000) , 'yellow',if((@currentField>=@now + 691200000) && (@currentField<@now + 1296000000), 'orange', if((@currentField>=@now + 0) && (@currentField<@now + 604800000),'red',' '))))"  
  }  
}  

Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.