MikeMike1Qrew Cadet7 years agoFormula HelpI'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 ...Show More
QuickBaseCoachDQrew CaptainNo problem, there was a clear error in my formulaChange that first part to thisvar number Count NumCompleted = Count( [checkbox 1], [checkbox 2],[checkbox 3]);
QuickBaseCoachDQrew Captain to QuickBaseCoachD7 years agoTry thisvar 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>")
Related ContentConditional formula urlYear Formula helpFormula URL - Edit then AddCreate a formula duration over 5 yearsLooking for State abbreviation to full spelling formula
Recent DiscussionsMany to Many too Many...Selecting which fields to display from Formula URL searchesBulk create child records from selection listSolved(Pipelines) Get Users in Role / Process XML from HTTP APIHelp Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting