Task Condition formula help?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I can't find what's wrong with this formula. Anyone want to put a fresh set of eyes on it? Thanks



If([Task Status]="Not Started" and Today()<=ToDate([Start]),"https://images.quickbase.com/si/16/222-point_green.png\" title=\"On Time "\">",



If([Task Status]="In Progress" and Today()<=ToDate([Projected Finish]), "https://images.quickbase.com/si/16/222-point_green.png\" title=\"On Time "\">",



If([Task Status]="Not Started" and Today()>ToDate([Start]), "https://images.quickbase.com/si/16/049-clock.png\" title=\"On Hold"\>",



If([Task Status]="In Progress" and Today()>ToDate([Projected Finish]), "https://images.quickbase.com/si/16/221-point_red.png\" title=\"Overdue\">",



If([Task Status]="Not Started" and Today()>ToDate([Start]), "https://images.quickbase.com/si/16/221-point_red.png\" title=\"Overdue\">",



If([Task Status]="Issue", "https://images.quickbase.com/si/16/223-point_yellow.png\" title=\"Issue "\">",



If([Task Status]="Complete", "https://images.quickbase.com/si/16/224-point_blue.png\" title=\ "Complete\">",



If([Task Status]="On Hold" or [Task Status]="Canceled","https://images.quickbase.com/si/16/220-point_gray.png\" title=\ "Inactive\">",

))))))))
Photo of Ian

Ian

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Try removing the very last comma.
Try removing the very last comma.
Photo of Ian

Ian

  • 0 Points
Nope, that didn't work. Thanks
What is the error message?
Hi Lan,

can you please share your error message ?

Thanks,
Gaurav
Photo of Ian

Ian

  • 0 Points
I attached a screenshot to the original post.
Can you please post a full screen shot of that error ?
I thing i can sure that you forgot to use the <img> taq in your formula.

Let me format this formula for you.
Hi Lan,

Try this formula and confirm if this is work for you.

If([Task Status]="Not Started" and Today()<=ToDate([Start]),
"<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"; title=\"On Time\">",

If([Task Status]="In Progress" and Today()<=ToDate([Projected Finish]),
"<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"; title=\"On Time\">",

If([Task Status]="Not Started" and Today()>ToDate([Start]),
"<img src=\"https://images.quickbase.com/si/16/049-clock.png\"; title=\"On Hold\">",

If([Task Status]="In Progress" and Today()>ToDate([Projected Finish]),
"<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",

If([Task Status]="Not Started" and Today()>ToDate([Start]),
"<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",

If([Task Status]="Issue",
"<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\"; title=\"Issue\">",

If([Task Status]="Complete",
"<img src=\"https://images.quickbase.com/si/16/224-point_blue.png\"; title=\"Complete\">",

If([Task Status]="On Hold" or [Task Status]="Canceled",
"<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">"

))))))))


Thanks,
Gaurav Sharma
Hi Lan,

Try this.
Photo of Ian

Ian

  • 0 Points
That worked. Thanks Gaurav!
That's great.

Please let me know if you need anything.
My contact info is in my profile.

Thanks,
Gaurav Sharma
Photo of Ian

Ian

  • 0 Points
I don't see your email address in your profile.
Photo of Ian

Ian

  • 0 Points
This formula isn't working either:

If([Project Status]="In Progress" and Today()<=ToDate([Projected Finish]),
"<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"; title=\"On Time\">",

If([Project Status]="On Hold",
"<img src=\"https://images.quickbase.com/si/16/049-clock.png\"; title=\"On Hold\">",

If([Project Status]="In Progress" and Today()>ToDate([Projected Finish]),
"<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",

If([Project Status]="Not Started" and Today()>ToDate([Projected Start]),
"<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",

If([Project Status]="Issue",
"<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\"; title=\"Issue\">",

If([Project Status]="Complete",
"<img src=\"https://images.quickbase.com/si/16/224-point_blue.png\"; title=\"Complete\">",

If([Project Status]="Canceled",
"<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Canceled\">"

)))))))
Hey Lan,

I have just updated my email address.
can you please tell me the error ?
Can you please remove semi-colon after the image url.
Photo of Ian

Ian

  • 0 Points
That didn't work.
Can you please confirm, is this a syntex error or function error ?
Photo of Ian

Ian

  • 0 Points
Formula error related to Date:


The types of the arguments or the number of arguments supplied do not meet the requirements of the function ToDate.

The function ToDate can be used with the following arguments:
ToDate (Text x).
ToDate (Text x, Text f).
ToDate (Date/Time x).
Hey Lan,

This is because you have used ToDate function with your date fields. as you can see this function only we can use with text or date/time function.Remove it and try again.

Thanks,
Gaurav
Photo of Ian

Ian

  • 0 Points
Thanks!