• 0
• Question
• Updated 3 years ago
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\">",

))))))))
• 0 Points

Posted 3 years ago

• 0
• 72,206 Points
Try removing the very last comma.
• 72,206 Points
Try removing the very last comma.
• 0 Points
Nope, that didn't work. Thanks
• 72,206 Points
What is the error message?
• 6,070 Points
Hi Lan,

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

Let me format this formula for you.
• 6,070 Points
Hi Lan,

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

"<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\">",

"<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\">",

"<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"; title=\"Overdue\">",

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

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

"<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\"; title=\"Inactive\">"

))))))))

Thanks,
Gaurav Sharma
• 6,070 Points
Hi Lan,

Try this.
• 0 Points
That worked. Thanks Gaurav!
• 6,070 Points
That's great.

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

Thanks,
Gaurav Sharma
• 0 Points
• 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\">"

)))))))
• 6,070 Points
Hey Lan,

I have just updated my email address.
can you please tell me the error ?
• 6,070 Points
Can you please remove semi-colon after the image url.
• 0 Points
That didn't work.
• 6,070 Points
Can you please confirm, is this a syntex error or function error ?
• 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).
• 6,070 Points
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
• 0 Points
Thanks!