search

bthuronyi / CloneCoordinate

CloneCoordinate issue tracking
1 stars 0 forks source link

GG Status (and possibly also Assemblies status) can have "ready to transform / ran out!" #248

Closed bthuronyi closed 1 month ago

bthuronyi commented 2 months ago

"Ran out!" should override "ready to transform" for gIDs and aIDs on their tabs.

ethanjeon commented 1 month ago

GG Status, right before the "ready to transform" line sum(iferror(arrayformula(value(split(textjoin(", ",TRUE,filter(Transformations_Transformed_amount,Transformations_Source_ID=B3)),","))),0))>=BF3,"ran out!", Assemblies Status, in analogous spot sum(iferror(arrayformula(value(split(textjoin(", ",TRUE,filter(Transformations_Transformed_amount,Transformations_Source_ID=B3)),", "))),0))>=N3,"ran out!",