using "and" in an URL formula

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Whats wrong with my formula



If(([Default Type]="Monetary" (and)[Threat]="Active"),"https://images.quickbase.com/si/32/449-auction.png\" title=\"Active "& [Default Type]&"\">",



If(([Default Type]="Non-Monetary" (and)[Threat]="Active"), "https://images.quickbase.com/si/32/448-auction_hammer.png\" title=\"Active "& [Default Type]&"\">")))
Photo of STEPHANIE

STEPHANIE

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,670 Points 50k badge 2x thumb
Remove the brackets around those two ands.

If(([Default Type]="Monetary" and [Threat]="Active"),"https://images.quickbase.com/si/32/449-auction.png\" title=\"Active "& [Default Type]&"\">",
Photo of STEPHANIE

STEPHANIE

  • 0 Points
Thanks Mark you rock!!!