Hello Together,
I would like to create an IF formula to categorize the "days" information what I got in the "Days until due date" column.
Do you have any idea what can be the issue? The error message show me "Invalid type in operator <."
Thansk in advance,
IF [Days until due date]>60
THEN "Overdue > 60 days"
ELSEIF [Days until due date]>31 and [Days until due date]<=60
THEN "Overdue 31-60 days"
ELSEIF [Days until due date]>21 and [Days until due date]<=30
THEN "Overdue 21-30 days"
ELSEIF [Days until due date]>11 and [Days until due date]<=20
THEN "Overdue 11-20 days"
ELSEIF [Days until due date]>=0 and [Days until due date]<=10
THEN "Overdue < 10 days"
ELSEIF [Days until due date]<0 and [Days until due date]>=-5
THEN "Due in 5 days"
ELSEIF [Days until due date]<-5 and [Days until due date]>=-10
THEN "Due in 10 days"
ELSEIF [Days until due date]<-10 and [Days until due date]>=-20
THEN "Due in 20 days"
ELSEIF [Days until due date]<-20
THEN "Due in 30 days"
ELSE ""
ENDIF
