Forum Discussion

JohnnyDeVilla1's avatar
JohnnyDeVilla1
Qrew Trainee
6 years ago

Formula adding fields, but leaving one out if a certain word

I have a formula to name records in one of my tables that is something like:
List(" - ",[Field1],[Field2],[Field3],[Field4],[Field5])

This works quite well for us, but when Field2 is selected as None I don't want None in the output. How would I write this so that when None it reads it as blank?

------------------------------
Johnny DeVilla
------------------------------
Formulas and functions
  • JohnnyDeVilla1's avatar
    JohnnyDeVilla1
    Qrew Trainee
    6 years ago
    my solution was to pull from another field that has this formula and works well
    List(", ",


    IF(Contains(ToText([Field2]), "Hedge Hogs"), "Hedge Hogs"),
    IF(Contains(ToText([Field2]), "Pink Ribbons"), "Pink Ribbons"),
    IF(Contains(ToText([Field2]), "None"), ""))

    ------------------------------
    Johnny DeVilla
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      I would have done this

      List(" - ",

      IF([Field1]<>"none",[Field 1]),
      IF([Field2]<>"none",[Field 2]),
      IF([Field3]<>"none",[Field 3]),
      IF([Field4]<>"none",[Field 4]),
      IF([Field5]<>"none",[Field 5]))

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • JohnnyDeVilla1's avatar
        JohnnyDeVilla1
        Qrew Trainee
        6 years ago
        Thanks that works well!!

        ------------------------------
        Johnny DeVilla
        ------------------------------