Problems with a Case Statement
I have a case statement I am trying to build using checkboxes to show what stage a particular report is sitting on (based on the completion of child record Tasks). The last line would the default resu...
Forum Discussion
Hi Mark,
Since this is of the same subject (problem with a case statement), I thought of raising this query in here. Here is my formula:
Case(
[Project Status],"Not Started", "<img src=\"https://images.quickbase.com/si/16/230-rect_blue.png\"; title=\"Not Started\">",
If([Actual End Date]>[Est End Date],"<img src=\"https://images.quickbase.com/si/16/227-rect_red.png\"; title=\"Project Overdue\">",
If(ToDays([Total Days Overdue])>0,"<img src=\"https://images.quickbase.com/si/16/170-alarm_clock.png\"; title=\"Milestone Overdue\">",
"<img src=\"https://images.quickbase.com/si/16/229-rect_yellow.png\"; title=\"On Time\">")),
"In Progress", "<img src=\"https://images.quickbase.com/si/16/229-rect_yellow.png\"; title=\"In Progress\">",
"Completed", "<img src=\"images.quickbase.com/si/16/228-rect_green.png\" title=\"Completed\">",
"On Hold", "<img src=\"https://images.quickbase.com/si/16/231-rect_violet.png\"; title=\"On Hold\">",
"Canceled", "<img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\"; title=\"Canceled\">")
When the above formula is used, only the "Not Started" condition is getting applied, for all other status, it is pulling up "Canceled" condition in 'image grey'. Can you help?
Since this is of the same subject (problem with a case statement), I thought of raising this query in here. Here is my formula:
Case(
[Project Status],"Not Started", "<img src=\"https://images.quickbase.com/si/16/230-rect_blue.png\"; title=\"Not Started\">",
If([Actual End Date]>[Est End Date],"<img src=\"https://images.quickbase.com/si/16/227-rect_red.png\"; title=\"Project Overdue\">",
If(ToDays([Total Days Overdue])>0,"<img src=\"https://images.quickbase.com/si/16/170-alarm_clock.png\"; title=\"Milestone Overdue\">",
"<img src=\"https://images.quickbase.com/si/16/229-rect_yellow.png\"; title=\"On Time\">")),
"In Progress", "<img src=\"https://images.quickbase.com/si/16/229-rect_yellow.png\"; title=\"In Progress\">",
"Completed", "<img src=\"images.quickbase.com/si/16/228-rect_green.png\" title=\"Completed\">",
"On Hold", "<img src=\"https://images.quickbase.com/si/16/231-rect_violet.png\"; title=\"On Hold\">",
"Canceled", "<img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\"; title=\"Canceled\">")
When the above formula is used, only the "Not Started" condition is getting applied, for all other status, it is pulling up "Canceled" condition in 'image grey'. Can you help?