What's wrong with my formula?


#1

Did I miss something? It was working until I tried to add two IS_BEFORE together

IF(IS_BEFORE({End Date},TODAY()) + (IS_BEFORE({Start Date}, TODAY()) > 1, “Upcoming Class”,“Previous Class”)


#2

Fixed it:

IF(IS_BEFORE({Start Date}, TODAY()) > 0, IF(IS_BEFORE({End Date}, TODAY()) > 0, “Previous Class”,“Current Class”),“Upcoming Class”)