Skip to main content
Question

Formula for a report - text triggers number

  • March 21, 2019
  • 0 replies
  • 26 views
I have a column in a report that I want to put a report formula column next to.  The initial column contains text and I want the formula column to put a numeric value based on the text in the first column.  Here's what I've come up with but it doesn't like something here.  Hope you can help.

If ([WRO] contains "W", .5, null )
If ([WRO] contains "R", 1, null )
    This topic has been closed for replies.

    Forum|alt.badge.img+12
    • LauraThacker
    • Quickbase Alumni
    • March 21, 2019
    This is how you write a Contains() statement for your situation: 

    If(Contains([WRO],"W"),5,
    If(Contains([WRO],"R"),1,
    null))


    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    Or shorter...

    If(
    Contains([WRO],"W"),5,
    Contains([WRO],"R"),1)
    • MarkGlevicky
    • Author
    • Quickbase Alumni
    • March 21, 2019
    THANK YOU!  Mark
    Terms & ConditionsAccessibility statement