Skip to main content
Solved

I am new to Quickbase

  • June 14, 2024
  • 0 replies
  • 123 views
Forum|alt.badge.img+1

I recently took over an existing Quickbase that involves approvals based on various data points -one table is use.  Recently, I have been asked to require  approvals for specific users based on two different text-multi select text boxes. It should fill in "approval is required" in the approval status.   I have been unable to combine the two fields.  I am adding to the existing field formula for the approval like this but I need to make "Sales Leader Required" only when both options are true and keep getting an error.  I have a large matrix that needs different approval based on the Renewal Discount and the Renewal ACV.

IF(

Contains(ToText([Renewal Discount]), "Within Threshold"),"<div style=\"color:red\"> "& "Sales Leader Approval Required" & "<div>",
Contains(ToText([Renewal ACV]), "<$100,000"), "<div style=\"color:red\"> "& "Sales Leader Approval Required" & "<div>",

"Sales Leader Approval Not Required"
)

 

 

Best answer by EverettPatterso

Try something like this

 

If(

Contains([Renewal Discount], "Within Threshold") and Contains([Renewal ACV], "<$100,000"),"<div style=\"color:red\"> "& "Sales Leader Approval Required" & "<div>",

"Sales Leader Approval Not Required"
)

This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10

Try something like this

 

If(

Contains([Renewal Discount], "Within Threshold") and Contains([Renewal ACV], "<$100,000"),"<div style=\"color:red\"> "& "Sales Leader Approval Required" & "<div>",

"Sales Leader Approval Not Required"
)

Terms & ConditionsAccessibility statement