Json code for use in a List Column to alert user on Date met conditions

Question

I am looking to put either a column formulae or relevant JSon code to conditionally format a calculated column [&DueStatus] using the following logic;

1. IF [&DueDate] date is equal to OR less than 30 days from Today's Date then alert to be 'DUE SOON" displayed in Yellow Text
2. IF [&DueDate] date is equal to OR less than 31 days from Today's Date then alert to be "OVERDUE" displayed in Red Text
3. IF [&DueDate] date is equal more than 30 days from Today's Date then alert to be "NO ACTION REQ"displayed in Green Text

Can anyone assist me?

Answer 1

Hi @Chris C,

Apologies for the late reply!

It is possible to create a calculated column that will calculate the day between today and Due Date.

Here is the reference about why we can't create a calculated column in your condition:

Any solution to the Today Calculated Column problem is SharePoint?

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

The Truth about using [Today] in SharePoint Calculated Columns

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

---

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.