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