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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Try removing the very last comma.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Try removing the very last comma.
Photo of Ian

Ian

  • 0 Points
Nope, that didn't work. Thanks
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
What is the error message?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
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.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Can you please post a full screen shot of that error ?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
I thing i can sure that you forgot to use the <img> taq in your formula.

Let me format this formula for you.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Hi Lan,

Try this.
Photo of Ian

Ian

  • 0 Points
That worked. Thanks Gaurav!
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
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\">"

)))))))
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Hey Lan,

I have just updated my email address.
can you please tell me the error ?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
Can you please remove semi-colon after the image url.
Photo of Ian

Ian

  • 0 Points
That didn't work.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
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).
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,884 Points 5k badge 2x thumb
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!