I am having trouble setting some automation. It works best if I explain I have three types of "Products" these products can be purchased Separately or as a collection. The can be "Completed" at different times. I collect the data as separate projects, but need to see them as a collection also ........ With that said Here is what I am trying to do.
If Collection is a Yes, I want Product A's , from Collection A, Active date Pasted to Cell X
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Y
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Z
See Image Below ....
If Collection is a Yes, I want Product A's , from Collection A, Active date Pasted to Cell X
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Y
AND
If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Z
See Image Below ....
![Capture567.png](/board/proxy.php?image=http%3A%2F%2Fphillipbsmith.com%2Fwp-content%2Fuploads%2F2019%2F05%2FCapture567.png&hash=178e81f89f89ffb5772e00ace66acc42)