Good Afternoon!
I have a spreadsheet where I track return requests and this is how I envision the process working:
A new row is enter into the sheet, column "W" is automatically populated via a formula with either "YES", "NO", or "Need Manager Approval". If the column contains "YES" an email is generated that contains info from the row formatted one way, if it contains a "NO", a different email is created that has info from the row, like a mail merge. If it contains "Need Manager Approval" nothing happens until it is manually changed to "YES" or "NO". I would also like to be able to change an already "processed" "NO" to a "YES" and generate the "YES" email, if for some reason management changes their mind.
I guess what I want to do is to monitor column "W" and once the row contains "YES" send the email and stop monitoring.
I hope this makes sense, it has been a long day and my head is throbbing....
<tbody>
</tbody>
I have a spreadsheet where I track return requests and this is how I envision the process working:
A new row is enter into the sheet, column "W" is automatically populated via a formula with either "YES", "NO", or "Need Manager Approval". If the column contains "YES" an email is generated that contains info from the row formatted one way, if it contains a "NO", a different email is created that has info from the row, like a mail merge. If it contains "Need Manager Approval" nothing happens until it is manually changed to "YES" or "NO". I would also like to be able to change an already "processed" "NO" to a "YES" and generate the "YES" email, if for some reason management changes their mind.
I guess what I want to do is to monitor column "W" and once the row contains "YES" send the email and stop monitoring.
I hope this makes sense, it has been a long day and my head is throbbing....
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
1 | Date | InvoiceNumber | PartNumber | Quantity | ReasonForReturn | SalesmanEmail | CustomerName | CustomerNumber | Zone | ShipTo | ShipToAddress | ShipToCity | ShipToState | ShipToZip | Bin | PartNumber2 | PartDescription | EmployeeNumber | InvoiceDate | SalePrice | Cost | PO | OK | MRANumber |
2 | 3/13/2018 | 3238785 | D40609HM0A | 1 | NEW RETURN | TEST@EMAIL.COM | VANGUARD CAR RENTAL USA INC | Z3204000 | 66 | 2NDRUN NCR PHILA | 7001 ESSINGTON AVE | PHILADELPHIA | PA | 00000 | 3330C | D4060-9HM0A | PAD KIT-DISC BR | 574 | 1/2/2018 | 17VMH21173 | Need Manager Approval | 100000 | ||
3 | 3/13/2018 | 3285415 | 95486483 | 1 | NEW RETURN | TEST@EMAIL.COM | PARKWAY A B OF NUTLEY | Z6629000 | 66 | 0 | 0 | 0 | 0 | 00000 | 1330C | 95486483 | APPLIQUE | 139 | 1/26/2018 | 10080 | YES | 100001 | ||
4 | 3/13/2018 | 3353137 | 95245217 | 1 | NEW RETURN | TEST@EMAIL.COM | ** RELIABLE AUTO BODY | Z8260603 | 66 | 0 | 0 | 0 | 0 | 00000 | 321D3A | 95245217 | BRACKET | 139 | 3/6/2018 | 2115 | NO | |||
5 | 3/13/2018 | 3351080 | T6653AA | 1 | CORE | TEST@EMAIL.COM | BOB HOPE AUTOMOTIVE | Z8885844 | 66 | 0 | 0 | 0 | 0 | 00000 | C114C C115C C114D | T6653AA | TRANS | 2230 | 3/6/2018 | 2012 ECONOLINE | YES | 100002 | ||
<tbody>
</tbody>