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”)
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”)
Fixed it:
IF(IS_BEFORE({Start Date}, TODAY()) > 0, IF(IS_BEFORE({End Date}, TODAY()) > 0, “Previous Class”,“Current Class”),“Upcoming Class”)