Forum Discussion
Winss
4 years agoQrew Trainee
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
4 years agoQrew Captain
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/
------------------------------
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/
------------------------------
- Winss4 years agoQrew TraineeRecord 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
------------------------------