I have a table "Products" and a table "Artworks". The Product table has a lookup field to the Artworks table. In this lookup field, I assigned multiple Artworks to each Product (e.g. "Product 1" has assigned "Artwork A", "Artwork B", "Artwork C", and "Artwork D").
Product 1 can only go into production once all Artworks assigned to Product 1 have approval status "Approved".
In the Products table, I added a rollup field that shows the records from the "Approval Status" field from the "Artworks" table. By default, the values appear like this in the rollup field: "Not submitted, not submitted, Approval pending, Approved"
Instead of listing all the records in the rollup field, I want the rollup field to show:
- IF all records = "Approved": output "ALL ARTWORKS APPROVED"
- ELSE: output "APPROVAL PENDING"
or alternatively:
- IF any record is not = "Approved": output "APPROVAL PENDING"
- ELSE: output "ALL ARTWORKS APPROVED"
I'm thankful for any tips!