Insert a ; or space into formula

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Formula reads:
var Text QTA = Part(UserListToNames([Quality Team]), 1, ";"); 
var Text QTB = Part(UserListToNames([Quality Team]), 2, ";");
var Text QTC = Part(UserListToNames([Quality Team]), 3, ";");
var Text QTD = Part(UserListToNames([Quality Team]), 4, ";");
var Text QTE = Part(UserListToNames([Quality Team]), 5, ";");

If (not Contains([Quality Approval], $QTA & "] Approved") and not Contains([Quality Approval], $QTA & "] Rejected"), $QTA) &
If (not Contains([Quality Approval], $QTB & "] Approved") and not Contains([Quality Approval], $QTB & "] Rejected"), $QTB) &
If (not Contains([Quality Approval], $QTC & "] Approved") and not Contains([Quality Approval], $QTC & "] Rejected"), $QTC) &


It comes out with all the names jumbled together.  
Photo of Sarah Bunten

Sarah Bunten

  • 694 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Can we see an example of the current result that you do not like and how you want it to appear?
Photo of Sarah Bunten

Sarah Bunten

  • 694 Points 500 badge 2x thumb
Appears: Waiting onButch Glenn Juan Caballero Matthew LensmireMawuena Gnamavo 

Wanting: Waiting on: Butch Glenn; Juan Caballero; Matthew Lensmire; Mawuena Gnamavo

I tried: 
If (not Contains([Quality Approval], $QTA & "] Approved") and not Contains([Quality Approval], $QTA & "] Rejected"), $QTA & ";") &

But the ";" appears even if the user is not there;  In other words it appears as:
Waiting on: Butch Glenn; Juan Caballero; Matthew Lensmire; Mawuena Gnamavo;;;;;
Ah, so what you want to use if the List function.  The list function separates a list of text phrases with a delimiter that you set, but is smart enough not to add the separator of there is nothing to separate.

So you want your separator to be "; "

List("; ",

If (not Contains([Quality Approval], $QTA & "] Approved") and not Contains([Quality Approval], $QTA & "] Rejected"), $QTA,

If (not Contains([Quality Approval], $QTB & "] Approved") and not Contains([Quality Approval], $QTB & "] Rejected"), $QTB),

If (not Contains([Quality Approval], $QTC & "] Approved") and not Contains([Quality Approval], $QTC & "] Rejected"), $QTC),


etc

)  // close the List ( open bracket)
Can you post the formula as text and not as an image.  Using the "pre" button will help it's legibility. No way I can read what you posted.
Photo of Sarah Bunten

Sarah Bunten

  • 694 Points 500 badge 2x thumb
var Text QTA = Part(UserListToNames([Quality Team]), 1, ";"); 
var Text QTB = Part(UserListToNames([Quality Team]), 2, ";");
var Text QTC = Part(UserListToNames([Quality Team]), 3, ";");
var Text QTD = Part(UserListToNames([Quality Team]), 4, ";");
var Text QTE = Part(UserListToNames([Quality Team]), 5, ";");
var Text QTF = Part(UserListToNames([Quality Team]), 6, ";");
var Text QTG = Part(UserListToNames([Quality Team]), 7, ";");
var Text QTH = Part(UserListToNames([Quality Team]), 8, ";");
var Text QTI = Part(UserListToNames([Quality Team]), 9, ";");
var Text QTJ = Part(UserListToNames([Quality Team]), 10, ";");

var Text CAA = Part(UserListToNames([CA Team]), 1, ";"); 
var Text CAB = Part(UserListToNames([CA Team]), 2, ";");
var Text CAC = Part(UserListToNames([CA Team]), 3, ";");
var Text CAD = Part(UserListToNames([CA Team]), 4, ";");

var Text QSTA = Part(UserListToNames([QST Team]), 1, ";"); 
var Text QSTB = Part(UserListToNames([QST Team]), 2, ";");
var Text QSTC = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTD = Part(UserListToNames([QST Team]), 4, ";");
var Text QSTE = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTF = Part(UserListToNames([QST Team]), 4, ";");

var Text OPA = Part(UserListToNames([Operations Team]), 1, ";"); 
var Text OPB = Part(UserListToNames([Operations Team]), 2, ";");
var Text OPC = Part(UserListToNames([Operations Team]), 3, ";");
var Text OPD = Part(UserListToNames([Operations Team]), 4, ";");
var Text OPE = Part(UserListToNames([Operations Team]), 5, ";");
var Text OPF = Part(UserListToNames([Operations Team]), 6, ";");
var Text OPG = Part(UserListToNames([Operations Team]), 7, ";");
var Text OPH = Part(UserListToNames([Operations Team]), 8, ";");

var Text WA = Part(UserListToNames([Welding Team]), 1, ";"); 
var Text WB = Part(UserListToNames([Welding Team]), 2, ";");
var Text WC = Part(UserListToNames([Welding Team]), 3, ";");
var Text WD = Part(UserListToNames([Welding Team]), 4, ";");

var Text CA = Part(UserListToNames([Coating Team]), 1, ";"); 
var Text CB = Part(UserListToNames([Coating Team]), 2, ";");
var Text CC = Part(UserListToNames([Coating Team]), 3, ";");
var Text CD = Part(UserListToNames([Coating Team]), 4, ";");

var Text HRA = Part(UserListToNames([HR Team]), 1, ";"); 
var Text HRB = Part(UserListToNames([HR Team]), 2, ";");
var Text HRC = Part(UserListToNames([HR Team]), 3, ";");
var Text HRD = Part(UserListToNames([HR Team]), 4, ";");

var Text PA = Part(UserListToNames([Purchasing Team]), 1, ";"); 
var Text PB = Part(UserListToNames([Purchasing Team]), 2, ";");
var Text PC = Part(UserListToNames([Purchasing Team]), 3, ";");
var Text PD = Part(UserListToNames([Purchasing Team]), 4, ";");

var Text MA = Part(UserListToNames([Materials Team]), 1, ";"); 
var Text MB = Part(UserListToNames([Materials Team]), 2, ";");
var Text MC = Part(UserListToNames([Materials Team]), 3, ";");
var Text MD = Part(UserListToNames([Materials Team]), 4, ";");

var Text EA = Part(UserListToNames([Engineering Team]), 1, ";"); 
var Text EB = Part(UserListToNames([Engineering Team]), 2, ";");
var Text EC = Part(UserListToNames([Engineering Team]), 3, ";");
var Text ED = Part(UserListToNames([Engineering Team]), 4, ";");

var Text NDTA = Part(UserListToNames([NDT Team]), 1, ";"); 
var Text NDTB = Part(UserListToNames([NDT Team]), 2, ";");
var Text NDTC = Part(UserListToNames([NDT Team]), 3, ";");
var Text NDTD = Part(UserListToNames([NDT Team]), 4, ";");


If (not Contains([Quality Approval], $QTA & "] Approved") and not Contains([Quality Approval], $QTA & "] Rejected"), $QTA) &
If (not Contains([Quality Approval], $QTB & "] Approved") and not Contains([Quality Approval], $QTB & "] Rejected"), $QTB) &
If (not Contains([Quality Approval], $QTC & "] Approved") and not Contains([Quality Approval], $QTC & "] Rejected"), $QTC) &
If (not Contains([Quality Approval], $QTD & "] Approved") and not Contains([Quality Approval], $QTD & "] Rejected"), $QTD) &
If (not Contains([Quality Approval], $QTE & "] Approved") and not Contains([Quality Approval], $QTE & "] Rejected"), $QTE) &
If (not Contains([Quality Approval], $QTF & "] Approved") and not Contains([Quality Approval], $QTF & "] Rejected"), $QTF) &
If (not Contains([Quality Approval], $QTG & "] Approved") and not Contains([Quality Approval], $QTG & "] Rejected"), $QTG) &
If (not Contains([Quality Approval], $QTH & "] Approved") and not Contains([Quality Approval], $QTH & "] Rejected"), $QTH) &
If (not Contains([Quality Approval], $QTI & "] Approved") and not Contains([Quality Approval], $QTI & "] Rejected"), $QTI) &
If (not Contains([Quality Approval], $QTJ & "] Approved") and not Contains([Quality Approval], $QTJ & "] Rejected"), $QTJ) &

If (not Contains([CA Approval], $CAA & "] Approved") and not Contains([CA Approval], $CAA & "] Rejected"), $CAA) &
If (not Contains([CA Approval], $CAB & "] Approved") and not Contains([CA Approval], $CAB & "] Rejected"), $CAB) &
If (not Contains([CA Approval], $CAC & "] Approved") and not Contains([CA Approval], $CAC & "] Rejected"), $CAC) &
If (not Contains([CA Approval], $CAD & "] Approved") and not Contains([CA Approval], $CAD & "] Rejected"), $CAD) &

If (not Contains([QST Approval], $QSTA & "] Approved") and not Contains([QST Approval], $QSTA & "] Rejected"), $QSTA) &
If (not Contains([QST Approval], $QSTB & "] Approved") and not Contains([QST Approval], $QSTB & "] Rejected"), $QSTB) &
If (not Contains([QST Approval], $QSTC & "] Approved") and not Contains([QST Approval], $QSTC & "] Rejected"), $QSTC) &
If (not Contains([QST Approval], $QSTD & "] Approved") and not Contains([QST Approval], $QSTD & "] Rejected"), $QSTD) &
If (not Contains([QST Approval], $QSTE & "] Approved") and not Contains([QST Approval], $QSTE & "] Rejected"), $QSTE) &
If (not Contains([QST Approval], $QSTF & "] Approved") and not Contains([QST Approval], $QSTF & "] Rejected"), $QSTF) &


If (not Contains([Operations Approval], $OPA & "] Approved") and not Contains([Operations Approval], $OPA &"] Rejected"), $OPA) &
If (not Contains([Operations Approval], $OPB & "] Approved") and not Contains([Operations Approval], $OPB &"] Rejected"), $OPB) &
If (not Contains([Operations Approval], $OPC & "] Approved") and not Contains([Operations Approval], $OPC &"] Rejected"), $OPC) &
If (not Contains([Operations Approval], $OPD & "] Approved") and not Contains([Operations Approval], $OPD &"] Rejected"), $OPD) &
If (not Contains([Operations Approval], $OPE & "] Approved") and not Contains([Operations Approval], $OPE &"] Rejected"), $OPE) &
If (not Contains([Operations Approval], $OPF & "] Approved") and not Contains([Operations Approval], $OPF &"] Rejected"), $OPF) &
If (not Contains([Operations Approval], $OPG & "] Approved") and not Contains([Operations Approval], $OPG &"] Rejected"), $OPG) &
If (not Contains([Operations Approval], $OPH & "] Approved") and not Contains([Operations Approval], $OPH &"] Rejected"), $OPH) &

If (not Contains([Welding Approval], $WA & "] Approved") and not Contains([Welding Approval], $WA & "] Rejected"), $WA) &
If (not Contains([Welding Approval], $WB & "] Approved") and not Contains([Welding Approval], $WB & "] Rejected"), $WB) &
If (not Contains([Welding Approval], $WC & "] Approved") and not Contains([Welding Approval], $WC & "] Rejected"), $WC) &
If (not Contains([Welding Approval], $WD & "] Approved") and not Contains([Welding Approval], $WD & "] Rejected"), $WD) &


If (not Contains([Coating Approval], $CA & "] Approved") and not Contains([Coating Approval], $CA & "] Rejected"), $CA) &
If (not Contains([Coating Approval], $CB & "] Approved") and not Contains([Coating Approval], $CB & "] Rejected"), $CB) &
If (not Contains([Coating Approval], $CC & "] Approved") and not Contains([Coating Approval], $CC & "] Rejected"), $CC) &
If (not Contains([Coating Approval], $CD & "] Approved") and not Contains([Coating Approval], $CD & "] Rejected"), $CD) &

If (not Contains([HR Approval], $HRA & "] Approved") and not Contains([HR Approval], $HRA & "] Rejected"), $HRA) &
If (not Contains([HR Approval], $HRB & "] Approved") and not Contains([HR Approval], $HRB & "] Rejected"), $HRB) &
If (not Contains([HR Approval], $HRC & "] Approved") and not Contains([HR Approval], $HRC & "] Rejected"), $HRC) &
If (not Contains([HR Approval], $HRD & "] Approved") and not Contains([HR Approval], $HRD & "] Rejected"), $HRD) &

If (not Contains([Purchasing Approval], $PA & "] Approved") and not Contains([Purchasing Approval], $PA & "] Rejected"), $PA) &
If (not Contains([Purchasing Approval], $PB & "] Approved") and not Contains([Purchasing Approval], $PB & "] Rejected"), $PB) &
If (not Contains([Purchasing Approval], $PC & "] Approved") and not Contains([Purchasing Approval], $PC & "] Rejected"), $PC) &
If (not Contains([Purchasing Approval], $PD & "] Approved") and not Contains([Purchasing Approval], $PD & "] Rejected"), $PD) &

If (not Contains([Materials Approval], $MA & "] Approved") and not Contains([Materials Approval], $MA & "] Rejected"), $MA) &
If (not Contains([Materials Approval], $MB & "] Approved") and not Contains([Materials Approval], $MB & "] Rejected"), $MB) &
If (not Contains([Materials Approval], $MC & "] Approved") and not Contains([Materials Approval], $MC & "] Rejected"), $MC) &
If (not Contains([Materials Approval], $MD & "] Approved") and not Contains([Materials Approval], $MD & "] Rejected"), $MD) &

If (not Contains([NDT Approval], $NDTA & "] Approved") and not Contains([NDT Approval], $NDTA & "] Rejected"), $NDTA) &
If (not Contains([NDT Approval], $NDTB & "] Approved") and not Contains([NDT Approval], $NDTB & "] Rejected"), $NDTB) &
If (not Contains([NDT Approval], $NDTC & "] Approved") and not Contains([NDT Approval], $NDTC & "] Rejected"), $NDTC) &
If (not Contains([NDT Approval], $NDTD & "] Approved") and not Contains([NDT Approval], $NDTD & "] Rejected"), $NDTD) &

If (not Contains([Engineering Approval], $EA & "] Approved") and not Contains([Engineering Approval], $EA & "] Rejected"), $EA) &
If (not Contains([Engineering Approval], $EB & "] Approved") and not Contains([Engineering Approval], $EB & "] Rejected"), $EB) &
If (not Contains([Engineering Approval], $EC & "] Approved") and not Contains([Engineering Approval], $EC & "] Rejected"), $EC) &
If (not Contains([Engineering Approval], $ED & "] Approved") and not Contains([Engineering Approval], $ED & "] Rejected"), $ED)
OK, now I can read the formula, but I do not see where you have used the List function.
Photo of Sarah Bunten

Sarah Bunten

  • 694 Points 500 badge 2x thumb
var Text QTA = Part(UserListToNames([Quality Team]), 1, ";"); 
var Text QTB = Part(UserListToNames([Quality Team]), 2, ";");
var Text QTC = Part(UserListToNames([Quality Team]), 3, ";");
var Text QTD = Part(UserListToNames([Quality Team]), 4, ";");
var Text QTE = Part(UserListToNames([Quality Team]), 5, ";");
var Text QTF = Part(UserListToNames([Quality Team]), 6, ";");
var Text QTG = Part(UserListToNames([Quality Team]), 7, ";");
var Text QTH = Part(UserListToNames([Quality Team]), 8, ";");
var Text QTI = Part(UserListToNames([Quality Team]), 9, ";");
var Text QTJ = Part(UserListToNames([Quality Team]), 10, ";");

var Text CAA = Part(UserListToNames([CA Team]), 1, ";"); 
var Text CAB = Part(UserListToNames([CA Team]), 2, ";");
var Text CAC = Part(UserListToNames([CA Team]), 3, ";");
var Text CAD = Part(UserListToNames([CA Team]), 4, ";");

var Text QSTA = Part(UserListToNames([QST Team]), 1, ";"); 
var Text QSTB = Part(UserListToNames([QST Team]), 2, ";");
var Text QSTC = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTD = Part(UserListToNames([QST Team]), 4, ";");
var Text QSTE = Part(UserListToNames([QST Team]), 3, ";");
var Text QSTF = Part(UserListToNames([QST Team]), 4, ";");

var Text OPA = Part(UserListToNames([Operations Team]), 1, ";"); 
var Text OPB = Part(UserListToNames([Operations Team]), 2, ";");
var Text OPC = Part(UserListToNames([Operations Team]), 3, ";");
var Text OPD = Part(UserListToNames([Operations Team]), 4, ";");
var Text OPE = Part(UserListToNames([Operations Team]), 5, ";");
var Text OPF = Part(UserListToNames([Operations Team]), 6, ";");
var Text OPG = Part(UserListToNames([Operations Team]), 7, ";");
var Text OPH = Part(UserListToNames([Operations Team]), 8, ";");

var Text WA = Part(UserListToNames([Welding Team]), 1, ";"); 
var Text WB = Part(UserListToNames([Welding Team]), 2, ";");
var Text WC = Part(UserListToNames([Welding Team]), 3, ";");
var Text WD = Part(UserListToNames([Welding Team]), 4, ";");

var Text CA = Part(UserListToNames([Coating Team]), 1, ";"); 
var Text CB = Part(UserListToNames([Coating Team]), 2, ";");
var Text CC = Part(UserListToNames([Coating Team]), 3, ";");
var Text CD = Part(UserListToNames([Coating Team]), 4, ";");

var Text HRA = Part(UserListToNames([HR Team]), 1, ";"); 
var Text HRB = Part(UserListToNames([HR Team]), 2, ";");
var Text HRC = Part(UserListToNames([HR Team]), 3, ";");
var Text HRD = Part(UserListToNames([HR Team]), 4, ";");

var Text PA = Part(UserListToNames([Purchasing Team]), 1, ";"); 
var Text PB = Part(UserListToNames([Purchasing Team]), 2, ";");
var Text PC = Part(UserListToNames([Purchasing Team]), 3, ";");
var Text PD = Part(UserListToNames([Purchasing Team]), 4, ";");

var Text MA = Part(UserListToNames([Materials Team]), 1, ";"); 
var Text MB = Part(UserListToNames([Materials Team]), 2, ";");
var Text MC = Part(UserListToNames([Materials Team]), 3, ";");
var Text MD = Part(UserListToNames([Materials Team]), 4, ";");

var Text EA = Part(UserListToNames([Engineering Team]), 1, ";"); 
var Text EB = Part(UserListToNames([Engineering Team]), 2, ";");
var Text EC = Part(UserListToNames([Engineering Team]), 3, ";");
var Text ED = Part(UserListToNames([Engineering Team]), 4, ";");

var Text NDTA = Part(UserListToNames([NDT Team]), 1, ";"); 
var Text NDTB = Part(UserListToNames([NDT Team]), 2, ";");
var Text NDTC = Part(UserListToNames([NDT Team]), 3, ";");
var Text NDTD = Part(UserListToNames([NDT Team]), 4, ";");

List(";",
If (not Contains([Quality Approval], $QTA & "] Approved") and not Contains([Quality Approval], $QTA & "] Rejected"), $QTA) &
If (not Contains([Quality Approval], $QTB & "] Approved") and not Contains([Quality Approval], $QTB & "] Rejected"), $QTB) &
If (not Contains([Quality Approval], $QTC & "] Approved") and not Contains([Quality Approval], $QTC & "] Rejected"), $QTC) &
If (not Contains([Quality Approval], $QTD & "] Approved") and not Contains([Quality Approval], $QTD & "] Rejected"), $QTD) &
If (not Contains([Quality Approval], $QTE & "] Approved") and not Contains([Quality Approval], $QTE & "] Rejected"), $QTE) &
If (not Contains([Quality Approval], $QTF & "] Approved") and not Contains([Quality Approval], $QTF & "] Rejected"), $QTF) &
If (not Contains([Quality Approval], $QTG & "] Approved") and not Contains([Quality Approval], $QTG & "] Rejected"), $QTG) &
If (not Contains([Quality Approval], $QTH & "] Approved") and not Contains([Quality Approval], $QTH & "] Rejected"), $QTH) &
If (not Contains([Quality Approval], $QTI & "] Approved") and not Contains([Quality Approval], $QTI & "] Rejected"), $QTI) &
If (not Contains([Quality Approval], $QTJ & "] Approved") and not Contains([Quality Approval], $QTJ & "] Rejected"), $QTJ) &

If (not Contains([CA Approval], $CAA & "] Approved") and not Contains([CA Approval], $CAA & "] Rejected"), $CAA) &
If (not Contains([CA Approval], $CAB & "] Approved") and not Contains([CA Approval], $CAB & "] Rejected"), $CAB) &
If (not Contains([CA Approval], $CAC & "] Approved") and not Contains([CA Approval], $CAC & "] Rejected"), $CAC) &
If (not Contains([CA Approval], $CAD & "] Approved") and not Contains([CA Approval], $CAD & "] Rejected"), $CAD) &

If (not Contains([QST Approval], $QSTA & "] Approved") and not Contains([QST Approval], $QSTA & "] Rejected"), $QSTA) &
If (not Contains([QST Approval], $QSTB & "] Approved") and not Contains([QST Approval], $QSTB & "] Rejected"), $QSTB) &
If (not Contains([QST Approval], $QSTC & "] Approved") and not Contains([QST Approval], $QSTC & "] Rejected"), $QSTC) &
If (not Contains([QST Approval], $QSTD & "] Approved") and not Contains([QST Approval], $QSTD & "] Rejected"), $QSTD) &
If (not Contains([QST Approval], $QSTE & "] Approved") and not Contains([QST Approval], $QSTE & "] Rejected"), $QSTE) &
If (not Contains([QST Approval], $QSTF & "] Approved") and not Contains([QST Approval], $QSTF & "] Rejected"), $QSTF) &


If (not Contains([Operations Approval], $OPA & "] Approved") and not Contains([Operations Approval], $OPA &"] Rejected"), $OPA) &
If (not Contains([Operations Approval], $OPB & "] Approved") and not Contains([Operations Approval], $OPB &"] Rejected"), $OPB) &
If (not Contains([Operations Approval], $OPC & "] Approved") and not Contains([Operations Approval], $OPC &"] Rejected"), $OPC) &
If (not Contains([Operations Approval], $OPD & "] Approved") and not Contains([Operations Approval], $OPD &"] Rejected"), $OPD) &
If (not Contains([Operations Approval], $OPE & "] Approved") and not Contains([Operations Approval], $OPE &"] Rejected"), $OPE) &
If (not Contains([Operations Approval], $OPF & "] Approved") and not Contains([Operations Approval], $OPF &"] Rejected"), $OPF) &
If (not Contains([Operations Approval], $OPG & "] Approved") and not Contains([Operations Approval], $OPG &"] Rejected"), $OPG) &
If (not Contains([Operations Approval], $OPH & "] Approved") and not Contains([Operations Approval], $OPH &"] Rejected"), $OPH) &

If (not Contains([Welding Approval], $WA & "] Approved") and not Contains([Welding Approval], $WA & "] Rejected"), $WA) &
If (not Contains([Welding Approval], $WB & "] Approved") and not Contains([Welding Approval], $WB & "] Rejected"), $WB) &
If (not Contains([Welding Approval], $WC & "] Approved") and not Contains([Welding Approval], $WC & "] Rejected"), $WC) &
If (not Contains([Welding Approval], $WD & "] Approved") and not Contains([Welding Approval], $WD & "] Rejected"), $WD) &


If (not Contains([Coating Approval], $CA & "] Approved") and not Contains([Coating Approval], $CA & "] Rejected"), $CA) &
If (not Contains([Coating Approval], $CB & "] Approved") and not Contains([Coating Approval], $CB & "] Rejected"), $CB) &
If (not Contains([Coating Approval], $CC & "] Approved") and not Contains([Coating Approval], $CC & "] Rejected"), $CC) &
If (not Contains([Coating Approval], $CD & "] Approved") and not Contains([Coating Approval], $CD & "] Rejected"), $CD) &

If (not Contains([HR Approval], $HRA & "] Approved") and not Contains([HR Approval], $HRA & "] Rejected"), $HRA) &
If (not Contains([HR Approval], $HRB & "] Approved") and not Contains([HR Approval], $HRB & "] Rejected"), $HRB) &
If (not Contains([HR Approval], $HRC & "] Approved") and not Contains([HR Approval], $HRC & "] Rejected"), $HRC) &
If (not Contains([HR Approval], $HRD & "] Approved") and not Contains([HR Approval], $HRD & "] Rejected"), $HRD) &

If (not Contains([Purchasing Approval], $PA & "] Approved") and not Contains([Purchasing Approval], $PA & "] Rejected"), $PA) &
If (not Contains([Purchasing Approval], $PB & "] Approved") and not Contains([Purchasing Approval], $PB & "] Rejected"), $PB) &
If (not Contains([Purchasing Approval], $PC & "] Approved") and not Contains([Purchasing Approval], $PC & "] Rejected"), $PC) &
If (not Contains([Purchasing Approval], $PD & "] Approved") and not Contains([Purchasing Approval], $PD & "] Rejected"), $PD) &

If (not Contains([Materials Approval], $MA & "] Approved") and not Contains([Materials Approval], $MA & "] Rejected"), $MA) &
If (not Contains([Materials Approval], $MB & "] Approved") and not Contains([Materials Approval], $MB & "] Rejected"), $MB) &
If (not Contains([Materials Approval], $MC & "] Approved") and not Contains([Materials Approval], $MC & "] Rejected"), $MC) &
If (not Contains([Materials Approval], $MD & "] Approved") and not Contains([Materials Approval], $MD & "] Rejected"), $MD) &

If (not Contains([NDT Approval], $NDTA & "] Approved") and not Contains([NDT Approval], $NDTA & "] Rejected"), $NDTA) &
If (not Contains([NDT Approval], $NDTB & "] Approved") and not Contains([NDT Approval], $NDTB & "] Rejected"), $NDTB) &
If (not Contains([NDT Approval], $NDTC & "] Approved") and not Contains([NDT Approval], $NDTC & "] Rejected"), $NDTC) &
If (not Contains([NDT Approval], $NDTD & "] Approved") and not Contains([NDT Approval], $NDTD & "] Rejected"), $NDTD) &

If (not Contains([Engineering Approval], $EA & "] Approved") and not Contains([Engineering Approval], $EA & "] Rejected"), $EA) &
If (not Contains([Engineering Approval], $EB & "] Approved") and not Contains([Engineering Approval], $EB & "] Rejected"), $EB) &
If (not Contains([Engineering Approval], $EC & "] Approved") and not Contains([Engineering Approval], $EC & "] Rejected"), $EC) &
If (not Contains([Engineering Approval], $ED & "] Approved") and not Contains([Engineering Approval], $ED & "] Rejected"), $ED)

)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
That's a lot of no code, low code
Interesting article that begrudgingly recognizes the need for code:

Do you really need developers to build applications?
"It's not at all low-code." - Quick Base CEO Rick Willet
http://www.zdnet.com/article/do-you-really-need-developers-to-build-applications/
The individual elements of the List need to be separated with a comma and not an &

see the comma at the end of each line





List("; ",
If (not Contains([Quality Approval], $QTA & "] Approved") and not Contains([Quality Approval], $QTA & "] Rejected"), $QTA) ,
If (not Contains([Quality Approval], $QTB & "] Approved") and not Contains([Quality Approval], $QTB & "] Rejected"), $QTB) ,
If (not Contains([Quality Approval], $QTC & "] Approved") and not Contains([Quality Approval], $QTC & "] Rejected"), $QTC) ,
If (not Contains([Quality Approval], $QTD & "] Approved") and not Contains([Quality Approval], $QTD & "] Rejected"), $QTD) ,
Photo of Sarah Bunten

Sarah Bunten

  • 694 Points 500 badge 2x thumb
Great!  Thanks!