Getting Started

 View Only
  • 1.  IF condition in Text field

    Posted 11-17-2022 08:17

    Hi there, 

    I have a [B!T Client Rating] Text field, it can contain numbers 1 to 5 or it can contain stars, so *, **, ***, ****, or *****. So I want to unify and convert the stars to numbers. I created a Formula text field and I put the following:

    if([B!T Client Rating] = "*",1, [B!T Client Rating])
    if([B!T Client Rating] = "**",2, [B!T Client Rating])
    if([B!T Client Rating] = "***",3, [B!T Client Rating])
    if([B!T Client Rating] = "****",4, [B!T Client Rating])
    if([B!T Client Rating] = "*****",5, [B!T Client Rating])

    It doesn't like the = in the first line. It says: "The operator "=" can't be applied on type numbers, text".

    Any ideas? Thanks!!





    ------------------------------
    Consuelo Viramonte
    ------------------------------


  • 2.  RE: IF condition in Text field

    Posted 11-17-2022 12:45
    Try this

    IF(
    [B!T Client Rating] 
    = "*",        "1",
    [B!T Client Rating] = "**",       "2",
    [B!T Client Rating] = "***",     "3",
    [B!T Client Rating] = "****",   "4",
    [B!T Client Rating] = "*****",  "5", [B!T Client Rating])

    If that does not work please post your formula and the complete error message.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: IF condition in Text field

    Posted 11-17-2022 13:00
    Thanks! it has worked!

    ------------------------------
    Consuelo Viramonte
    ------------------------------