Formula Help
I'm attempting to create a series of colorized progress trackers, based on a number of requirements. To do so, I'm trying to colorize a field based on a number of checkboxes. Example: I have ...
Forum Discussion
No problem, there was a clear error in my formula
Change that first part to this
var number Count NumCompleted =
Count( [checkbox 1], [checkbox 2],[checkbox 3]);
Change that first part to this
var number Count NumCompleted =
Count( [checkbox 1], [checkbox 2],[checkbox 3]);
Try this
var number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);
Case($Count,0,
"<img src=https://images.quickbase.com/si/32/221-point_red.png>",
1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>",
2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>",
3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")
var number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);
Case($Count,0,
"<img src=https://images.quickbase.com/si/32/221-point_red.png>",
1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>",
2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>",
3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")