Discussions

Expand all | Collapse all

Insert a ; or space into formula

Archive User03-15-2018 20:56

  • 1.  Insert a ; or space into formula

    Top
    Contributor
    Posted 03-15-2018 19:17
    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.  


  • 2.  RE: Insert a ; or space into formula

    Posted 03-15-2018 19:32
    Can we see an example of the current result that you do not like and how you want it to appear?


  • 3.  RE: Insert a ; or space into formula

    Top
    Contributor
    Posted 03-15-2018 19:37
    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;;;;;


  • 4.  RE: Insert a ; or space into formula

    Posted 03-15-2018 19:44
    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)


  • 5.  RE: Insert a ; or space into formula

    Top
    Contributor
    Posted 03-15-2018 19:47


  • 6.  RE: Insert a ; or space into formula

    Posted 03-15-2018 19:49
    I would need to see your whole formula to debug it.


  • 7.  RE: Insert a ; or space into formula

    Top
    Contributor
    Posted 03-15-2018 19:50
    I've tried the list because it seemed the best option but I am not sure what I am doing wrong.  Do I need to do a list for each team? 



  • 8.  RE: Insert a ; or space into formula

    Posted 03-15-2018 19:57
    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.


  • 9.  RE: Insert a ; or space into formula

    Top
    Contributor
    Posted 03-15-2018 20:20
    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)


  • 10.  RE: Insert a ; or space into formula

    Posted 03-15-2018 20:22
    OK, now I can read the formula, but I do not see where you have used the List function.


  • 11.  RE: Insert a ; or space into formula

    Top
    Contributor
    Posted 03-15-2018 20:33
    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)

    )


  • 12.  RE: Insert a ; or space into formula

    Top
    Contributor
    Posted 03-16-2018 13:42
    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/


  • 13.  RE: Insert a ; or space into formula

    Posted 03-15-2018 20:44
    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) ,


  • 14.  RE: Insert a ; or space into formula

    Top
    Contributor
    Posted 03-15-2018 20:56
    Great!  Thanks!