JavaScript, Google Script writing with IF function and mail automation.

Google App script Writing for XL.

From the Google sheet attached I would need the below.,

  1. IF C2 value is > M2 then a mail should trigger. WHich will have the current price, Stock Name. (Else if F2 become T1 then mails should trigger which will have stock_name, current Price.).
  2. Similarly the above will be same for T2 & T3.
  3. IF C2 value is <= P2 mail should trigger. (Else if C2 becomes SL then mail should trigger.)
  4. if C25 is => E25 trigger mai.(Else if L25 becomes Buy trigger mail.)

This should check all the XL sheet. Should be able to add a new line or remove lines which are SL or T3.

Create a Freelance Profile to apply.

Apply Now Call