Hi,
Thank you for the automation. The automation however does not work as required.
The point of the additional condition was to ensure the automation only wrote the row that contained product information in the orders spreadsheet to the master (the correct row(s) can be identified because they are the only row(s) within the order with a value in Column F (Vendor).
However in the automation file you posted this condition does not seem to be followed. (The other conditions are working fine however).
The error in this condition can be seen by the following explanation:
The OrderNumber in (column C) of the orders spreadsheet contains a variety of rows (product information, GST information and shipping information).
After all other conditions have been met, I do not want to write the rows which contain text 'gst' and 'shipping'.
The rows that contain a value in Column F (Vendor) are the actual rows that I want to write to the master. (I am using the value in Column F (Vendor) to identify the correct rows to write because the rows containing the 'gst' and 'shipping' text contain blank values in Column F (vendor)).
I have also attached a screenshot to further demonstrate this point.
Please can you amend and repost?
Thanks and regards.
|