About IF statment
Hello everyoune, please I need your help with this isuue because I almost gave up to answer it. Please I appreciate your help
I would to apply either IF/IF And statment to the formula.
The logical thinking is:
IF (end date-today()) =0 and the description is not empty Then "completed" But if and description=" " then "no data"
IF (end date-today())<0 and >=-2Then "late"
IF (end date-today())>=-3 and description=" " Then "no data"
IF (start date >today()) Then "not started"
IF we are still in the time frame between start date and end date + the description is not empty Then "In progress"
Help Article Resources
Check out the Formula Handbook template!