Hi, I am trying to figure a way to do a text based sum up. I am trying to keep track of the parts I 3D Print for each order. One order can have many parts. Each Part has a enum Status. When all the Related Parts Status is Complete, I want a virtual column to return Complete on the Parent Order.
I have [Related Parts][Status] returning all of the related statusss correctly, but I am not sure how to do the rest. I am sure I am overthinking it. IF(AND()) dont seem to be working (I get a “Cannot compare List with Text” error), and I have also looked into Array formulas with no success. Any guidance would be greatly appreciated.
IF(AND([Related Parts][Status]= “Complete”, “Complete”, “Processing”))