Forum Discussion

itimatic's avatar
itimatic
Frequent Visitor
5 years ago
Solved

If else complex statement

Hello! Can anyone help in correcting this if statment? I'm getting error "Token Eof expected" IF [started_at] = NULL and [done] = NULL and [cancelled] = NULL then "Not started" else IF [starte...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    small "if".

    I haven't looked at the logic but fix that first.

itimatic's avatar
itimatic
Frequent Visitor
5 years ago

Thanks for your hint,. it worked now. this is the final formula for reference:

if [started_at] = null and [done] = null and [cancelled] = null then "Not started"
else if [started_at] <> null and [done] = null and [cancelled] = null then "Ongoing"
else if [done] <> null then "Completed"
else if [cancelled] <> null then "Cancelled" else "N/A")