Forum Discussion

shass's avatar
shass
Qrew Member
7 months ago

I am new to Quickbase

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 d...
formulas
  • EverettPatterso's avatar
    EverettPatterso
    7 months ago

    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"
    )

EverettPatterso's avatar
EverettPatterso
Qrew Captain
7 months ago

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"
)

  • shass's avatar
    shass
    Qrew Member
    7 months ago

    Thank you so much for the help!  I thought I had to include ToText since that is how all the IF statements are currently written.