Forum Discussion

Winss's avatar
Winss
Qrew Trainee
4 years ago

Multiple if without leaving else part

I want to use multiple if in my formula multi-select where I'm searching for some text in the list & if a text is found then i have to give null output but if not found then a list as output I want to...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Any kind of logic is possible but I think we would need an actual example of the data in some fields and the results you want in order to help you with that formula.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • Winss's avatar
    Winss
    Qrew Trainee
    4 years ago

    Here is the code. The formula is multi-select. I'm tracking what are pending processes.

    If(Contains([Combined Text Completed Processes],"Process 1"),split(""),Split("Process 1"),

if(Contains([Combined Text Completed Processes],"Process 1") and Contains([Combined Text Completed Processes],"Process 2"),split(""),Split(List(" ; ","Process 1","Process 2")),

if(Contains([Combined Text Completed Processes],"Process 1") and Contains([Combined Text Completed Processes],"Process 2") and Contains([Combined Text Completed Processes],"Process 3"),split(""),Split(List(" ; ","Process 1","Process 2","Process 3")),

if(Contains([Combined Text Completed Processes],"Process 1") and Contains([Combined Text Completed Processes],"Process 2") and Contains([Combined Text Completed Processes],"Process 3") and Contains([Combined Text Completed Processes],"Process 4"),split(""),Split(List(" ; ","Process 1","Process 2","Process 3","Process 4"))​


    ------------------------------
    Winss Albo
    ------------------------------
    • BlakeHarrison's avatar
      BlakeHarrison
      Qrew Captain
      4 years ago
      Ok, but can you provide an example of what the "Combined Text Completed Processes" values look like along with an example of the output you expect the formula to produce for each of the examples you provided for the field? Example:

      Field Value                      Expected Formula Value
      Process 2; Process 3          Two and Three
      Process 4                              Four

      ------------------------------
      Blake Harrison
      bharrison@datablender.io
      DataBlender - Quickbase Solution Provider
      Atlanta GA
      404.800.1702 / http://datablender.io/
      ------------------------------
      • Winss's avatar
        Winss
        Qrew Trainee
        4 years ago
        Record Id | Combined Text Completed Process |  Pending
            1                 [Process 1]   [Process 3]                         [Process 2] [Process 4]
             2                [Process 2] [Process 3]                          [Process 1] [Process 4]

        Here "Pending" is field that i want multiple if condition formula for without leaving the else part as i described in previous thread.
        Combined Text Completed Process is a summary field from child records text field, later which I bought to this table as a look up field.

        ------------------------------
        Winss Albo
        ------------------------------