Im looking at trying to create a traffic light format rule for scheduled sessions in my app.
Today or in the future = Green | [Latest Session] >= TODAY()
I week in the past = Yellow | [Latest Session] < TODAY() - 7
Older than one week but not including the previous week = Red | I cant seem to get this one to work It keeps overriding the previous rule.
Does anyone have any suggestions?