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