I wish to modify an existing spreadsheet to send an email when a cell reaches a certain value. I also would like to dismiss the value when data is entered into the following cell.
I found an example/tutorial online at '[url removed, login to view]', but I am not skilled enough to apply this information to my existing document.
I am unsure of how much information to include in this initial request.
Tab: DWG Orders
Column F 'Date Ordered'
Column G 'Today'
Column H 'Days Pending'
Column I 'Date Received'
When today's date reaches 5 business days from the Date Ordered, I would like an email sent to a specific address. I would also like to void this action when data is entered into the Date Received cell. I suppose we could get sassy and have the body of the email 'list' the applicable row data (I.E. 113T1958-8 LWG Boeing KUTD # 26911 10/17/13 02/17/14 88) or whatever.
I realize this is embarrassingly lowbrow stuff, but that is where I am.
Thank you very much for your time.
24 freelancers are bidding on average $344 for this job
I am interested working this task. I can rest assured to fulfill this task in timely manner. I am looking forward for your response to get started working thank you. Regards, Jay
I am very interested in taking on this project! I have 10 years office experience and I am now a stay at home mom! I have the time to commit to doing a great job! Hope you consider my bid! Thank you!