Insert a ; or space into formula
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, "...
Forum Discussion
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)
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)
- I would need to see your whole formula to debug it.
- 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?
- 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.
- 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.
- 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)
) 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/
