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.
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:
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
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?
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:
