I am trying to get something to work on SharePoint Online with JSON column formatting. What i have currently been able to achieve was, if a column is filled in ==> fill green if empty fill orange. I would like to convert this to a date-based check.
For example: When the column contains data = Fill it as green & show text in white
If todays date = or is less then the date in LaunchDate Column AND the field is empty ==> Fill it red
todays date equals or is more then 1 month before LaunchDate ==> Fill Yellow
1 month or less before launch date =:=> fill Orange.
I am struggeling with stringing this all together. Any ideas?
After applying solution suggested below i get as result(i emptied an expired field to illustrate: