Help

Multiple checkboxes consolidated to a text field

Topic Labels: Formulas
Solved
Jump to Solution
1199 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

Hi Folks, 

I'm currently struggling with a formula. I'm trying to track the progress of a project that requires an asset to be translated to several languages. I created checkboxes for each language and for when those assets were QC'd. I'd love to be able to consolidate all the checkboxes to a single text field so I can easily see which languages have been completed and QC'd. I've been able to create a formula to pull a checkbox per language but now I'm adding the second step of QC and my IF AND formula isn't working. Below is a sample of the formula that worked and the one that isn't once I added the second step. 

TRIM(IF(
({BR Art}),
"BR, "
)
&
IF(
({DE Art}),
"DE, "
)
&
IF(
({FR Art}),
"FR, "
)
&
IF(
({IT Art}),
"IT, "
)
&
IF(
({JP Art}),
"JP, "
)
&
IF(
({MX Art}),
"MX "
)
)

 

The two step I was testing out

IF(
AND(
{BR Art},
{BR Art QC}
),
"BR, ",

IF(
AND(
{MX Art},
{MX Art QC}
),
"MX, ",

IF(
AND(
{IT Art},
({IT Art QC}
),
"IT",
BLANK()
)
)
)

 

1 Solution

Accepted Solutions

Ah, apologies.  I looked at my previous reply and realized I left some extra code in there that didn't really do anything and was confusing matters. 

I've looked at your code and made some modifications and it seems to save fine now:

IF(
  AND(
    {AR Art},
    {AR Art QC}
  ),
  "AR, "
) & 
IF(
  AND(
    {BR Art},
    {BR Art QC}
  ),
  "BR, "
) & 
IF(
  AND(
    {CN Art},
    {CN Art QC}
  ),
  "CN, "
) & 
IF(
  AND(
    {CZ Art},
    {CZ Art QC}
  ),
  "CZ, "
) & 
IF(
  AND(
    {DE Art},
    {DE Art QC}
  ),
  "DE, "
) & 
IF(
  AND(
    {DK Art},
    {DK Art QC}
  ),
  "DK, "
) & 
IF(
  AND(
    {FI Art},
    {FI Art QC}
  ),
  "FI, "
) & 
IF(
  AND(
    {FR Art},
    {FR Art QC}
  ),
  "FR, "
) & 
IF(
  AND(
    {HU Art},
    {HU Art QC}
  ),
  "HU, "
) & 
IF(
  AND(
    {IN Art},
    {IN Art QC}
  ),
  "IN, "
) & 
IF(
  AND(
    {IT Art},
    {IT Art QC}
  ),
  "IT, "
) & 
IF(
  AND(
    {JP Art},
    {JP Art QC}
  ),
  "JP"
) & 
IF(
  AND(
    {MX Art},
    {MX Art QC}
  ),
  "MX, "
) & 
IF(
  AND(
    {NL Art},
    {NL Art QC}
  ),
  "NL, "
) & 
IF(
  AND(
    {NO Art (Norway)},
    {NO Art (Norway)}
  ),
  "NO, "
) & 
IF(
  AND(
    {PL Art},
    {PL Art QC}
  ),
  "PL, "
) & 
IF(
  AND(
    {RO Art},
    {RO Art QC}
  ),
  "RO, "
) & 
IF(
  AND(
    {TH Art},
    {TH Art QC}
  ),
  "TH, "
) & 
IF(
  AND(
    {VT Art},
    {VT Art QC}
  ),
  "VT"
)

See Solution in Thread

5 Replies 5

Any chance you could duplicate your base and provide an invite link to it?  It would make helping you with this issue a lot easier as one would be able to see the fields and how the base is set up and would also allow for troubleshooting directly in your base without having to create a base ourselves

Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

Sorry it took a while for me to set this up but hope this helps show how it might work

https://airtable.com/shrOTI0XDnrObuzVu/tblLRLHRsMzODvIPn/viw15rIqPWBLfXr2Y?blocks=hide 

 

Thanks for the base!

I've changed it a bit and this seems to work:

 

IF(
	AND(
		{BR Art},
		{BR Art QC}
	),
	"BR, "
) & 
IF(
	AND(
		{MX Art},
		{MX Art QC}
	),
	"MX, "
) & 
IF(
	AND(
		{IT Art},
		{IT Art QC}
	),
	"IT"
)

 

 

Thank you so much! I tried to use this and expand it to include all the fields and for some reason I keep getting an error. I've gone through it a few times and can't figure out why. Any advice? 

IF(
  AND(
    {AR Art},
    {AR Art QC}
  ),
  "AR, "
) & 
IF(
  AND(
    {BR Art},
    {BR Art QC}
  ),
  "BR, "
) & 
IF(
  AND(
    {CN Art},
    {CN Art QC}
  ),
  "CN",
) & 
IF(
  AND(
    {CZ Art},
    {CZ Art QC}
  ),
  "CZ, "
) & 
IF(
  AND(
    {DE Art},
    {DE Art QC}
  ),
  "DE, "
) & 
IF(
  AND(
    {DK Art},
    {DK Art QC}
  ),
  "DK",
) & 
IF(
  AND(
    {FI Art},
    {FI Art QC}
  ),
  "FI, "
) & 
IF(
  AND(
    {FR Art},
    {FR Art QC}
  ),
  "FR, "
) & 
IF(
  AND(
    {HU Art},
    {HU Art QC}
  ),
  "HU",
) & 
IF(
  AND(
    {IN Art},
    {IN Art QC}
  ),
  "IN, "
) & 
IF(
  AND(
    {IT Art},
    {IT Art QC}
  ),
  "IT, "
) & 
IF(
  AND(
    {JP Art},
    {JP Art QC}
  ),
  "JP",
) & 
IF(
  AND(
    {MX Art},
    {MX Art QC}
  ),
  "MX, "
) & 
IF(
  AND(
    {NL Art},
    {NL Art QC}
  ),
  "NL, "
) & 
IF(
  AND(
    {NO Art (Norway)},
    {NO Art (Norway)}
  ),
  "NO",
) & 
IF(
  AND(
    {PL Art},
    {PL Art QC}
  ),
  "PL, "
) & 
IF(
  AND(
    {RO Art},
    {RO Art QC}
  ),
  "RO, "
) & 
IF(
  AND(
    {TH Art},
    {TH Art QC}
  ),
  "TH",
) & 
IF(
  AND(
    {VT Art},
    {VT Art QC}
  ),
  "VT",
  BLANK()
)

Ah, apologies.  I looked at my previous reply and realized I left some extra code in there that didn't really do anything and was confusing matters. 

I've looked at your code and made some modifications and it seems to save fine now:

IF(
  AND(
    {AR Art},
    {AR Art QC}
  ),
  "AR, "
) & 
IF(
  AND(
    {BR Art},
    {BR Art QC}
  ),
  "BR, "
) & 
IF(
  AND(
    {CN Art},
    {CN Art QC}
  ),
  "CN, "
) & 
IF(
  AND(
    {CZ Art},
    {CZ Art QC}
  ),
  "CZ, "
) & 
IF(
  AND(
    {DE Art},
    {DE Art QC}
  ),
  "DE, "
) & 
IF(
  AND(
    {DK Art},
    {DK Art QC}
  ),
  "DK, "
) & 
IF(
  AND(
    {FI Art},
    {FI Art QC}
  ),
  "FI, "
) & 
IF(
  AND(
    {FR Art},
    {FR Art QC}
  ),
  "FR, "
) & 
IF(
  AND(
    {HU Art},
    {HU Art QC}
  ),
  "HU, "
) & 
IF(
  AND(
    {IN Art},
    {IN Art QC}
  ),
  "IN, "
) & 
IF(
  AND(
    {IT Art},
    {IT Art QC}
  ),
  "IT, "
) & 
IF(
  AND(
    {JP Art},
    {JP Art QC}
  ),
  "JP"
) & 
IF(
  AND(
    {MX Art},
    {MX Art QC}
  ),
  "MX, "
) & 
IF(
  AND(
    {NL Art},
    {NL Art QC}
  ),
  "NL, "
) & 
IF(
  AND(
    {NO Art (Norway)},
    {NO Art (Norway)}
  ),
  "NO, "
) & 
IF(
  AND(
    {PL Art},
    {PL Art QC}
  ),
  "PL, "
) & 
IF(
  AND(
    {RO Art},
    {RO Art QC}
  ),
  "RO, "
) & 
IF(
  AND(
    {TH Art},
    {TH Art QC}
  ),
  "TH, "
) & 
IF(
  AND(
    {VT Art},
    {VT Art QC}
  ),
  "VT"
)