The problem here is you are using a fresh IF statement for each line, when in Quickbase you shouldn't do that.
You should enter the formula this way:
"IF([Main Processing Unit]="Retirement Services","",
[Main Processing Unit]="0000202 AVAYA","0000202 AVAYA",
[Main Processing Unit]="0000250 CWA PAYERS NO CNTRCT-ATT LEGACY","0000250 CWA PAYERS NO CNTRCT-ATT LEGACY",
....
[Main Processing Unit]="Carolyn Williams","","")
So on every line except line 1 you need to remove If(
And on every line except the final line you need to remove the "")
Once you do that it should all work.
The formula highlights the first instance of an error it finds, not every error in the formula. so when you fix one, it may highlight another error further along.
Thank you so much!
Does each IF statement need to have 3 arguments? In other words,
([Main Processing Unit]="Retirement Services","",
vs.
[Main Processing Unit]="0000202 AVAYA","0000202 AVAYA",
I would want the first statement to result in just blank when it matches "Retirement Services" and the second would result in "0000202 AVAYA" when it matches, however, for the second statement, do I need to add a 'False' argument?
No, the third parameter is optional per the docs:
"The else-result is optional. If omitted, QuickBase assumes it's null (or empty - a blank)."
Looking at your logic, you may want to consider the Case() function instead, but If() works too. Or perhaps it'd be better to store the Unit Types as its own table to track additional data points about each Unit? Then, relate the Types back to your parent table and use lookups to pull-in what would've been the results of the formula instead?
Regardless, here is a tidied version of your initial question! Please double check if you do you "in production!"
If ( [Main Processing Unit] = "Retirement Services", "", [Main Processing Unit] = "0000202 AVAYA", "0000202 AVAYA", [Main Processing Unit] = "0000250 CWA PAYERS NO CNTRCT-ATT LEGACY", "0000250 CWA PAYERS NO CNTRCT-ATT LEGACY", [Main Processing Unit] = "LOCAL 3250 - Ringer Hailes", "", [Main Processing Unit] = "0000250 CWA PAYERS NO CNTRCT-ATT LEGACY", "0000250 CWA PAYERS NO CNTRCT-ATT LEGACY", [Main Processing Unit] = "0003401 - QWEST-LUMEN", "0003401 - QWEST-LUMEN", [Main Processing Unit] = "0003450 CWA PAYERS NO CNTRCT-QWEST", "0003450 CWA PAYERS NO CNTRCT-QWEST,0137701 DENVER PUB SCHOOLS", [Main Processing Unit] = "0003450 CWA PAYERS NO CNTRCT-QWEST", "0003450 CWA PAYERS NO CNTRCT-QWEST", [Main Processing Unit] = "0005550 CWA PAYERS NO CNTRCT-ATT / PTT", "0000405 FRONTIER (Formally VZ-GTE CA),0005550 CWA PAYERS NO CNTRCT-ATT / PTT", [Main Processing Unit] = "0005550 CWA PAYERS NO CNTRCT-ATT / PTT", "0005501 ATT / PTT,0005550 CWA PAYERS NO CNTRCT-ATT / PTT", [Main Processing Unit] = "0007505 FRONTIER (Formally VZ-TX) 0645401 WINDSTREAM 0007550 CWA PAYER NO CONTRCT-VERIZON", "0007505 FRONTIER (Formally VZ-TX) 0645401 WINDSTREAM 0007550 CWA PAYER NO CONTRCT-VERIZON", [Main Processing Unit] = "0006201 FRONTIER - CITIZENS ROCHESTER NY", "0006201 FRONTIER - CITIZENS ROCHESTER NY", [Main Processing Unit] = "0008050 - CWA PAYERS NO CNTRCT-ATT Susan Stoll", "", [Main Processing Unit] = "0008050 - CWA PAYERS NO CNTRCT-ATT Susan Stoll", "", [Main Processing Unit] = "0011501 WOOD CTY TELCO-dba SOLARUS", "0011501 WOOD CTY TELCO-dba SOLARUS", [Main Processing Unit] = "0014101 HARRISONVILLE TEL CO", "0014101 HARRISONVILLE TEL CO", [Main Processing Unit] = "0014501 CCI TELCOM GRP B - LOCAL 6218 - Fairpoint", "0014501 CCI TELCOM GRP B - LOCAL 6218 - Fairpoint", [Main Processing Unit] = "0020901 VERIZON NEW ENGLAND INC", "0020901 VERIZON NEW ENGLAND INC", [Main Processing Unit] = "0024901 GARDEN VALLEY TEL CO", "0024901 GARDEN VALLEY TEL CO", [Main Processing Unit] = "0043501 NYC GVT ADM TTLS EMP 0043550 CWA PAYERS NO CNTRCT", "0043501 NYC GVT ADM TTLS EMP 0043550 CWA PAYERS NO CNTRCT", [Main Processing Unit] = "0043550 CWA PAYERS NO CNTRCT", "0043501 NYC GVT ADM TTLS EMP,0043550 CWA PAYERS NO CNTRCT", [Main Processing Unit] = "0053001 ADT CLVLND-AKRON-CNCNTTI-DETRT", "0053001 ADT CLVLND-AKRON-CNCNTTI-DETRT", [Main Processing Unit] = "0053003 JOHNSON CONTROLS - TYCO - D4 LOCALS", "0053003 JOHNSON CONTROLS - TYCO - D4 LOCALS,0283802 TYCO - 7704,0750501 JOHNSON CONTROLS SECURITY SOLUTIONS LLC,0757401 JOHNSON CONTROLS - D6", [Main Processing Unit] = "0070801 ARNOT OGDEN MED CTR", "0070801 ARNOT OGDEN MED CTR", [Main Processing Unit] = "0073401 UNION CNTY OF-(WELFARE BD)", "0073401 UNION CNTY OF-(WELFARE BD)", [Main Processing Unit] = "0075001 ESSEX CO DIVISION WELFARE", "0075001 ESSEX CO DIVISION WELFARE,0289201 ESSEX CO WELFARE BRD CLERICAL", [Main Processing Unit] = "0075701 MIDDLESEX CO BRD OF SOCIAL SVCS", "0075701 MIDDLESEX CO BRD OF SOCIAL SVCS", [Main Processing Unit] = "0075701 Middlesex County Board of Social Services", "", [Main Processing Unit] = "0081601 EAST ORANGE (dues)", "0081601 EAST ORANGE (dues)", [Main Processing Unit] = "0082301 CAMDEN BRD OF ED", "0082301 CAMDEN BRD OF ED", [Main Processing Unit] = "0102201 CAMDEN CO WELFARE BRD", "0102201 CAMDEN CO WELFARE BRD", [Main Processing Unit] = "0107401 Burlington CO Welfare Brd", "0000007 COPE Dummy PU,0107401 Burlington CO Welfare Brd", [Main Processing Unit] = "Local 1091", "", [Main Processing Unit] = "0118701 OCEAN CO WELFARE BRD (NON SUP)", "0118701 OCEAN CO WELFARE BRD (NON SUP)", [Main Processing Unit] = "Ocean County BSS", "", [Main Processing Unit] = "0126201 KINGDOM TEL CO PLT", "0126201 KINGDOM TEL CO PLT", [Main Processing Unit] = "0130001 BERGEN CTY BRD OF SCL SVCS-L1089", "0130001 BERGEN CTY BRD OF SCL SVCS-L1089,0745401 BERGEN CTY BRD OF SCL SVCS -L1031", [Main Processing Unit] = "0130801 OCN CTY BLUE CLR CS E", "0130801 OCN CTY BLUE CLR CS E", [Main Processing Unit] = "Local 13500", "", [Main Processing Unit] = "0145801 FL KEYS AQUEDUCT AUTH", "0145801 FL KEYS AQUEDUCT AUTH", [Main Processing Unit] = "0148901 MORRIS CO[.] OTA NON-SPV", "0148901 MORRIS CO[.] OTA NON-SPV", [Main Processing Unit] = "0153101 ST LUCIE CTY SCHL BRD", "0153101 ST LUCIE CTY SCHL BRD", [Main Processing Unit] = "0159801 INDIAN RV CNTY SC BD", "0159801 INDIAN RV CNTY SC BD", [Main Processing Unit] = "0176101 VISITNG NURSES ASSC OF WSTRN NY", "0176101 VISITNG NURSES ASSC OF WSTRN NY", [Main Processing Unit] = "0185801 Hunterdon Cty", "0185801 Hunterdon Cty", [Main Processing Unit] = "0188101 SALEM CTY", "0188101 SALEM CTY", [Main Processing Unit] = "0190301 GLOUCESTER CTY EM (01)", "0190301 GLOUCESTER CTY EM (01), 0677001 GLOUCESTER/SHADY LANE NURSING", [Main Processing Unit] = "0190301 GLOUCESTER CTY EM (01)", "0190301 GLOUCESTER CTY EM (01),0677001 GLOUCESTER/SHADY LANE NURSING", [Main Processing Unit] = "0190801 TRENTON HOUSING AUTH", "0190801 TRENTON HOUSING AUTH", [Main Processing Unit] = "0190803 WEST WINDSOR TWNSHP", "0190803 WEST WINDSOR TWNSHP", [Main Processing Unit] = "0201301 NJ STATE EMPLOYEES ADMN CLERICAL", "0201301 NJ STATE EMPLOYEES ADMN CLERICAL,0201350 CWA PAYERS NO CNTRCT", [Main Processing Unit] = "0201301 NJ STATE EMPLOYEES ADMN CLERICAL", "0000007 COPE Dummy PU,0201301 NJ STATE EMPLOYEES ADMN CLERICAL,0201350 CWA PAYERS NO CNTRCT", [Main Processing Unit] = "0201301 NJ STATE EMPLOYEES ADMN CLERICAL", "0201301 NJ STATE EMPLOYEES ADMN CLERICAL", [Main Processing Unit] = "0201302 ROWAN COLL", "0201302 ROWAN COLL", [Main Processing Unit] = "0201304 RAMAPO COLL OF NJ", "0201304 RAMAPO COLL OF NJ", [Main Processing Unit] = "0201305 PALISADES INTRST PRK", "0201305 PALISADES INTRST PRK", [Main Processing Unit] = "0201311 STOCKTON ST COLL", "0201311 STOCKTON ST COLL", [Main Processing Unit] = "0201312 NJ CITY UNIV", "0000007 COPE Dummy PU, 0201312 NJ CITY UNIV", [Main Processing Unit] = "0201312 NJ CITY UNIV", "0000007 COPE Dummy PU,0201312 NJ CITY UNIV", [Main Processing Unit] = "0201313 MONTCLAIR ST COLL", "0201313 MONTCLAIR ST COLL", [Main Processing Unit] = "CWA LOCAL 1036", "CWA LOCAL 1036", [Main Processing Unit] = "0201350 CWA PAYERS NO CNTRCT", "", [Main Processing Unit] = "0201350- LOCAL 1036", "0201350- LOCAL 1036", [Main Processing Unit] = "0201350 CWA PAYERS NO CNTRCT", "0201350 CWA PAYERS NO CNTRCT", [Main Processing Unit] = "0201301 NJ STATE EMPLOYEES ADMN CLERICAL", "0000007 COPE Dummy PU, 0201301 NJ STATE EMPLOYEES ADMN CLERICAL, 0201350 CWA PAYERS NO CNTRCT", [Main Processing Unit] = "LOCAL 1037", "", [Main Processing Unit] = "Local 1038", "", [Main Processing Unit] = "0201350 - LOCAL 1038 0000007 - Local 1038 0201301 - LOCAL 1038", "0201350 - LOCAL 1038 0000007 - Local 1038 0201301 - LOCAL 1038", [Main Processing Unit] = "0201351 LOCAL 1032 STAFF UNIT", "0201351 LOCAL 1032 STAFF UNIT", [Main Processing Unit] = "0204101 PALM BEACH CTY", "0204101 PALM BEACH CTY", [Main Processing Unit] = "0204101 - Local 3181", "0204101 - Local 3181", [Main Processing Unit] = "0211201 KALEIDA BGH RN", "0211201 KALEIDA BGH RN,0211202 KALEIDA BGH TCC,0211205 MILLARD FILLMORE RNS,0211206 MILLARD TCC,0211207 FLINT PROFESSIONAL,0211209 KALEIDA BGH PROFESSIONAL,0258801 KALEIDA DEGRAFF TCCS", [Main Processing Unit] = "0534701 MERCY HOSP OF BUFFALO-RN", "0534701 MERCY HOSP OF BUFFALO-RN,0534702 MERCY HOSP OF BUFFALO-STC", [Main Processing Unit] = "0211201 KALEIDA BGH RN 0211205 MILLARD FILLMORE RNS 02158801", "0211201 KALEIDA BGH RN 0211205 MILLARD FILLMORE RNS 02158801", [Main Processing Unit] = "0211201 KALEIDA BGH RN 0211205 MILLARD FILLMORE RNS 0258801 KALEIDA DEGRAFF TCCS", "0211201 KALEIDA BGH RN 0211205 MILLARD FILLMORE RNS 0258801 KALEIDA DEGRAFF TCCS", [Main Processing Unit] = "0218901 AMERICAN FED OF GOVT EMPLOYEES", "0218901 AMERICAN FED OF GOVT EMPLOYEES", [Main Processing Unit] = "Local 2201", "", [Main Processing Unit] = "0220501 OCEAN CITY FREE PUB LIB (PT)", "0220501 OCEAN CITY FREE PUB LIB (PT)", [Main Processing Unit] = "0224702 St[.]Luke Mem Hosp Ctr LPN TECH-SEMC", "0224702 St[.]Luke Mem Hosp Ctr LPN TECH-SEMC", [Main Processing Unit] = "0224702 - ST LUKES MEM HOSP - SEMC", "0224702 - ST LUKES MEM HOSP - SEMC", [Main Processing Unit] = "0236501 MARLBORO TWP", "", [Main Processing Unit] = "CWA LOCAL 13500", "CWA LOCAL 13500", [Main Processing Unit] = "0240301 MIDSTATE COMM", "0240301 MIDSTATE COMM", [Main Processing Unit] = "Planned Parenthood", "", [Main Processing Unit] = "0268501 - CUYAHOGA CO SHERIFFS DEPT", "0268501 - CUYAHOGA CO SHERIFFS DEPT", [Main Processing Unit] = "0268501 CUYAHOGA COUNTY SHERIFFS DEPT", "0268501 CUYAHOGA COUNTY SHERIFFS DEPT", [Main Processing Unit] = "0760501 CC CLERKS OF COURTS", "0760501 CC CLERKS OF COURTS", [Main Processing Unit] = "0268501 CUYAHOGA CO SHERIFFS DEPT", "0268501 CUYAHOGA CO SHERIFFS DEPT", [Main Processing Unit] = "0272101 CENTRIS FEDERAL CREDIT UNION", "0272101 CENTRIS FEDERAL CREDIT UNION", [Main Processing Unit] = "0272401 STARK CTY HOUSING", "0272401 STARK CTY HOUSING", [Main Processing Unit] = "0298501 NEW YORK PRESBYTERIAN HOSPTAL", "0298501 NEW YORK PRESBYTERIAN HOSPTAL", [Main Processing Unit] = "0306906 - LOCAL 9400 (SEIU)", "0306906 - LOCAL 9400 (SEIU)", [Main Processing Unit] = "0307403 SEIU", "0307403 SEIU,0521901 SERVICE EMP INTER UNION [#]105", [Main Processing Unit] = "0307405 CO WINS - STAFF UNIT", "0307405 CO WINS - STAFF UNIT", [Main Processing Unit] = "0308323 PENINSULA SCHL DIST-", "0308323 PENINSULA SCHL DIST-", [Main Processing Unit] = "0507401 SHAWNEE STATE UNVRSY", "0507401 SHAWNEE STATE UNVRSY", [Main Processing Unit] = "0508001 RUTGERS UNIV", "0508001 RUTGERS UNIV", [Main Processing Unit] = "0516901 OCCUPTNL TRNG CTR BURLNGTN CTY", "0516901 OCCUPTNL TRNG CTR BURLNGTN CTY", [Main Processing Unit] = "0516902 OCCUPATNAL TC BURLNGTN (Client)", "0516902 OCCUPATNAL TC BURLNGTN (Client)", [Main Processing Unit] = "0516902 OCCUPTNL TRNG CTR BURLNGTN CTY", "0516902 OCCUPTNL TRNG CTR BURLNGTN CTY", [Main Processing Unit] = "0519301 STATE OF TEXAS", "0519301 STATE OF TEXAS,0529701 KLRU PUB TELEVISION,0748601 WORKERS ASSISTANCE PROGRAM", [Main Processing Unit] = "0519301 STATE OF TEXAS", "0519301 STATE OF TEXAS", [Main Processing Unit] = "0519401 OKLAHOMA STATE WKERS", "0519401 OKLAHOMA STATE WKERS", [Main Processing Unit] = "0523201 PASSAIC CTY PREAKNESS", "0523201 PASSAIC CTY PREAKNESS", [Main Processing Unit] = "0541701 BUTTE COMM COLL DSTRCT(PFA)", "0541701 BUTTE COMM COLL DSTRCT(PFA)", [Main Processing Unit] = "0546001 OVERBROOK EMPL ASSOC - Cty of Essex", "0546001 OVERBROOK EMPL ASSOC - Cty of Essex", [Main Processing Unit] = "0546801 ST[.] JOSEPH CAMPUS RN", "0546801 ST[.] JOSEPH CAMPUS RN", [Main Processing Unit] = "0546801 ST[.] JOSEPH CAMPUS RN", "0546801 ST[.] JOSEPH CAMPUS RN,0718601 ST[.] JOSEPH CAMPUS SVC", [Main Processing Unit] = "0552101 SOMERSET CTY RECYCLING CTR", "0552101 SOMERSET CTY RECYCLING CTR", [Main Processing Unit] = "0561602 FOX SPORTS PROD SVCS", "0561602 FOX SPORTS PROD SVCS", [Main Processing Unit] = "0561901 NBA PROPERTIES", "0561901 NBA PROPERTIES", [Main Processing Unit] = "0563701 WICU-TV (SJL)", "0563701 WICU-TV (SJL)", [Main Processing Unit] = "0564201 WJBK (FOX)", "0564201 WJBK (FOX)", [Main Processing Unit] = "0564401 WJRT-TV (AMB)", "0564401 WJRT-TV (AMB)", [Main Processing Unit] = "0565801 WSKG (PUB BRDCST)", "0565801 WSKG (PUB BRDCST)", [Main Processing Unit] = "0568203 CITADEL RADIO (CUMULUS) - DC RADIO", "0568203 CITADEL RADIO (CUMULUS) - DC RADIO", [Main Processing Unit] = "0569026 Non-Checkoff LOCAL 51", "0569026 Non-Checkoff LOCAL 51", [Main Processing Unit] = "0577301 SEIU LOCAL 503", "0577301 SEIU LOCAL 503", [Main Processing Unit] = "0581801 PPCWNY PROF - MED CLERKS", "0581801 PPCWNY PROF - MED CLERKS", [Main Processing Unit] = "0587301 ARMS ACRES INC", "0587301 ARMS ACRES INC", [Main Processing Unit] = "0587401 CONIFER PARK INC", "0587401 CONIFER PARK INC", [Main Processing Unit] = "0595101 PASSAIC CTY BD OF SOCIAL SVCS", "0595101 PASSAIC CTY BD OF SOCIAL SVCS", [Main Processing Unit] = "0606601 AFT-WEST VIRGINIA", "0606601 AFT-WEST VIRGINIA", [Main Processing Unit] = "Kenneth Valero", " Individual Contributor", [Main Processing Unit] = "0618901 FRONTIER - L1298", "0618901 FRONTIER - L1298", [Main Processing Unit] = "CWA Retirement", "", [Main Processing Unit] = "0625801 KENMORE MERCY HOSP", "0625801 KENMORE MERCY HOSP", [Main Processing Unit] = "0630501 COLL OF SEQUOIAS COMM COLL DST", "0630501 COLL OF SEQUOIAS COMM COLL DST", [Main Processing Unit] = "0636501 MV TRANSPORTATION", "0636501 MV TRANSPORTATION", [Main Processing Unit] = "0645201 UNIV HOSP-HEALTH SCI[.]", "0645201 UNIV HOSP-HEALTH SCI[.]", [Main Processing Unit] = "0645401 WINDSTREAM", "0007505 FRONTIER (Formally VZ-TX),0007550 CWA PAYER NO CONTRCT-VERIZON,0645401 WINDSTREAM", [Main Processing Unit] = "City of Tucson", "", [Main Processing Unit] = "0666201 COLUMBUS CITY OF", "0666201 COLUMBUS CITY OF", [Main Processing Unit] = "CWA LOCAL 9588", "CWA LOCAL 9588", [Main Processing Unit] = "0680701 ESSEX ARC", "0680701 ESSEX ARC", [Main Processing Unit] = "0701201 SEIU - COMMITTEE OF INTERNSRES", "0701201 SEIU - COMMITTEE OF INTERNSRES", [Main Processing Unit] = "0701501 KALEIDA - FAMILY PHARMACEUTICAL", "0701501 KALEIDA - FAMILY PHARMACEUTICAL", [Main Processing Unit] = "0703301 SEIU LOCAL 1021", "0703301 SEIU LOCAL 1021", [Main Processing Unit] = "0703801 HELP INC[.]", "0703801 HELP INC[.]", [Main Processing Unit] = "0704301 NJ HOUSING AND MORTGAGE-ADMIN", "0704301 NJ HOUSING AND MORTGAGE-ADMIN,0704302 NJ HOUSING AND MORTGAGE-PROF", [Main Processing Unit] = "0704302 NJ HOUSING AND MORTGAGE-PROF", "0704302 NJ HOUSING AND MORTGAGE-PROF", [Main Processing Unit] = "0705301 NJ PERFORMING ARTS CTR", "0705301 NJ PERFORMING ARTS CTR", [Main Processing Unit] = "0711701 MITCHELL TELECOM", "0711701 MITCHELL TELECOM", [Main Processing Unit] = "0720101 ALA-ALASKA AIRLINES", "0720101 ALA-ALASKA AIRLINES", [Main Processing Unit] = "0720101 ALA-ALASKA AIRLINES", "0000007 COPE Dummy PU, 0720101 ALA-ALASKA AIRLINES, 0720601 HZN-HORIZON AIRLINES", [Main Processing Unit] = "0720101 ALA-ALASKA AIRLINES", "0000007 COPE Dummy PU,0720101 ALA-ALASKA AIRLINES,0720601 HZN-HORIZON AIRLINES", [Main Processing Unit] = "0720301 ARW-AIR WISCONSIN", "0720301 ARW-AIR WISCONSIN", [Main Processing Unit] = "0722701 MSA-MESA AIRLINES", "0722701 MSA-MESA AIRLINES", [Main Processing Unit] = "0741801 TWAIN HARTE COMM SVC DIST", "0741801 TWAIN HARTE COMM SVC DIST", [Main Processing Unit] = "0759701 CAMDEN CTY MOSQUITO COMMISSION", "0759701 CAMDEN CTY MOSQUITO COMMISSION,0760301 CAMDEN CTY PROSECUTOR,0760401 COUNTY OF CAMDEN COUNTY - LARGE,0760404 COUNTY OF CAMDEN - SUPERVISORY", [Main Processing Unit] = "0759801 CITY OF CAMDEN - Non Supervisory", "0759801 CITY OF CAMDEN - Non Supervisory,0759802 CITY OF CAMDEN - SUPERVISORY", [Main Processing Unit] = "0760201 GLOUCESTER TWP - ADMINISTRATIVE STAFF", "0760201 GLOUCESTER TWP - ADMINISTRATIVE STAFF", [Main Processing Unit] = "0760401 COUNTY OF CAMDEN COUNTY - LARGE", "0759701 CAMDEN CTY MOSQUITO COMMISSION,0760301 CAMDEN CTY PROSECUTOR,0760401 COUNTY OF CAMDEN COUNTY - LARGE,0760404 COUNTY OF CAMDEN - SUPERVISORY", [Main Processing Unit] = "0760401 COUNTY OF CAMDEN COUNTY - LARGE", "0760401 COUNTY OF CAMDEN COUNTY - LARGE", [Main Processing Unit] = "Oregon Federation of Nurses Health Professionals", "", [Main Processing Unit] = "0777101 Ziply-L7670", "0777101 Ziply-L7670", [Main Processing Unit] = "0777401 Univ of CO (UCW)", "0537301 Denver Public Library,0777301 Denver Health,0777401 Univ of CO (UCW),0777501 Univ of CO Hospital - - UCHWU", [Main Processing Unit] = "0779701 Kentucky Public Colleges Universities (UCW)", "0779701 Kentucky Public Colleges Universities (UCW)", [Main Processing Unit] = "0780201 University of Arizona (UCW)", "0780201 University of Arizona (UCW),0780301 Arizona State University (UCW)", [Main Processing Unit] = "CWA LOCAL 7065 OC", "CWA LOCAL 7065 OC", [Main Processing Unit] = "CWA LOCAL 7799 OC", "CWA LOCAL 7799 OC", [Main Processing Unit] = "0788901 OR Federation of Nurses Health Prof - OFNHP", "0788901 OR Federation of Nurses Health Prof - OFNHP", [Main Processing Unit] = "0790001 DTV - DirecTV Cust Svc - Mobility", "0790001 DTV - DirecTV Cust Svc - Mobility", [Main Processing Unit] = "0800147 BAE SYS", "0800147 BAE SYS", [Main Processing Unit] = "0800147 BAE Systems", "0800147 BAE Systems", [Main Processing Unit] = "0800212 D MAX", "0800212 D MAX, 0826950 CWA PAYERS NO CONTRACT, 0827601 DIVERSEY/DUBOIS CORPORATION, 0897401 DRIV Automotive", [Main Processing Unit] = "0800212 D MAX", "", [Main Processing Unit] = "0800212 D MAX", "0800212 D MAX", [Main Processing Unit] = "0800212 D MAX", "0800212 D MAX,0826950 CWA PAYERS NO CONTRACT,0827601 DIVERSEY/DUBOIS CORPORATION,0897401 DRIV Automotive", [Main Processing Unit] = "0800302 HAIER", "0800302 HAIER", [Main Processing Unit] = "0810101 HUBBELL POWER-A[.]B[.] CHANCE COMPANY", "0810101 HUBBELL POWER-A[.]B[.] CHANCE COMPANY", [Main Processing Unit] = "0811101 AUTOMATIC FIRE ALARM", "0811101 AUTOMATIC FIRE ALARM", [Main Processing Unit] = "0813601 ACCU BLADES", "0813601 ACCU BLADES", [Main Processing Unit] = "0818001 NORTHSTAR AEROSPACE", "0818001 NORTHSTAR AEROSPACE", [Main Processing Unit] = "0818701 BOSTON TEACHERS UNION", "0818701 BOSTON TEACHERS UNION", [Main Processing Unit] = "0819001 BROADACRES NURSING HOME", "0819001 BROADACRES NURSING HOME", [Main Processing Unit] = "0825601 CROWN CORK SEAL", "0825601 CROWN CORK SEAL", [Main Processing Unit] = "0826901 DAYTON-PHOENIX GRP INC", "0826901 DAYTON-PHOENIX GRP INC", [Main Processing Unit] = "0826901 Dayton Phoenix Group", "", [Main Processing Unit] = "0830101 VISIONWORKS", "0830101 VISIONWORKS", [Main Processing Unit] = "0836401 MAGNETECH INDUSTRIAL", "0836401 MAGNETECH INDUSTRIAL", [Main Processing Unit] = "0839801 MINEBEA ACCESS SOLUTIONS-HONDA LOCK", "0839801 MINEBEA ACCESS SOLUTIONS-HONDA LOCK", [Main Processing Unit] = "0839901 OVERHEAD DOOR/HORTON AUTOMATICS", "0839901 OVERHEAD DOOR/HORTON AUTOMATICS", [Main Processing Unit] = "0841901 Elbit Sys - Night Vision", "0841901 Elbit Sys - Night Vision", [Main Processing Unit] = "0844501 ABB-Crystal Springs PGTR", "0844501 ABB-Crystal Springs PGTR", [Main Processing Unit] = "0845501 LAPP INSULATOR COMPANY LLC", "0845501 LAPP INSULATOR COMPANY LLC", [Main Processing Unit] = "0845502 Pfisterer North America", "0845502 Pfisterer North America", [Main Processing Unit] = "Local 84757", "", [Main Processing Unit] = "0847601 LOCKHEED MARTIN", "0847601 LOCKHEED MARTIN", [Main Processing Unit] = "0847801 LOCKHEED MARTIN", "0847801 LOCKHEED MARTIN", [Main Processing Unit] = "0852101 B-WAY CORPORATION", "0852101 B-WAY CORPORATION", [Main Processing Unit] = "0852301 CTY OF MONROE", "0852301 CTY OF MONROE", [Main Processing Unit] = "National Electrical Carbon Products", "", [Main Processing Unit] = "0855301 NORTHROP GRUMMAN CORP", "0855301 NORTHROP GRUMMAN CORP", [Main Processing Unit] = "0856001 General Dynamics Mission Sys", "0856001 General Dynamics Mission Sys", [Main Processing Unit] = "0857501 WEG TRANSFORMERS", "0857501 WEG TRANSFORMERS", [Main Processing Unit] = "0860801 MORGAN ADVANCED MATERIALS", "0860801 MORGAN ADVANCED MATERIALS", [Main Processing Unit] = "0865401 LEGGETT PLATT", "0865401 LEGGETT PLATT", [Main Processing Unit] = "0869201 STEEL WAREHOUSE CO INC", "0869201 STEEL WAREHOUSE CO INC", [Main Processing Unit] = "0873801 Winchester Interconnect", "0873801 Winchester Interconnect", [Main Processing Unit] = "0875701 VALCOR ENGINEERING", "0875701 VALCOR ENGINEERING", [Main Processing Unit] = "0876301 EATON AEROSPACE (VICKERS INCORPO", "0876301 EATON AEROSPACE (VICKERS INCORPO", [Main Processing Unit] = "0876501 VIRGINIA TRANSFORMER CORPORATION", "0876501 VIRGINIA TRANSFORMER CORPORATION", [Main Processing Unit] = "0877701 WAYNE CTY DEPT[.] OF SOCIAL SER", "0877701 WAYNE CTY DEPT[.] OF SOCIAL SER", [Main Processing Unit] = "0897401 DRIV Automotive", "0800212 D MAX,0826901 DAYTON-PHOENIX GRP INC,0826950 CWA PAYERS NO CONTRACT,0827601 DIVERSEY/DUBOIS CORPORATION,0897401 DRIV Automotive", [Main Processing Unit] = "1156923 TYPE UNION NO 6", "1156923 TYPE UNION NO 6", [Main Processing Unit] = "1156933 TYPO UNION [#]6 COMMITTEE", "1156644 LAW JOURNAL EDITORIAL/PRODUCTION,1156901 NEW YORK TIMES,1156923 TYPE UNION NO 6,1156933 TYPO UNION [#]6 COMMITTEE,1156644 LAW JOURNAL EDITORIAL/PRODUCTION,1156901 NEW YORK TIMES,1156923 TYPE UNION NO 6", [Main Processing Unit] = "CWA LOCAL 51016", "CWA LOCAL 51016", [Main Processing Unit] = "NABET Local 59051", "", [Main Processing Unit] = "Sherrie Thompson", "", [Main Processing Unit] = "Sherrie Thompson", "", [Main Processing Unit] = "CWA LOCAL 84800", "CWA LOCAL 84800", [Main Processing Unit] = "Local 1168", "", [Main Processing Unit] = "Carolyn Williams", "",
// Default "")
Thank you so much! This was incredibly helpful!
Maybe too late, but looking at that formula it looks like it might be better development to create a child table of Main Processing Units. Each main processing unit would have a Name, and the Nickname. Select the processing unit and you can look up the nickname, eliminating the need for a complicated If formula you need to keep adding to. This way, you simply just add to your child table.
