Google App script Writing for XL.
From the Google sheet attached I would need the below.,
- 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.).
- Similarly the above will be same for T2 & T3.
- IF C2 value is <= P2 mail should trigger. (Else if C2 becomes SL then mail should trigger.)
- 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.