How do I create a stoplight/traffic light status column without changing the view to the basic table style? I would like to create the status column in the default table style not basic table style.
I need to create a traffic light or colored dot for a Modern SharePoint list of documents that need to be updated each year. The list, below, shows a Due Date for each item on the list. The Due Date is a calculated field based on the Last Date updated plus one year. The traffic light or color dot will be in the column called Status and will indicate the following. Does anyone have the JSON code for this? (Note that I used the color code format for the dates in the Due Date column, but the colors are not the red, green and yellow that I need.) Thank you.
If the Due Date is fewer than 7 days away, the dot will be Red.
If the Due Date is fewer than 14 days away, the dot will be Yellow.
If the Due Date is greater than or equal to 14 days away, the dot will be Green.
