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