Forum Discussion
ColSaxena
Jul 04, 2023Copper Contributor
Getting SMS from my Excel file for specific dates to my own phone
I have used the following formula in my Excelsheet, in an extra column "B" as under:- =IF(A2=TODAY(),,"C2&D2&E2&F2""") But, it is giving an error message. How do I get over this issue?
Riny_van_Eekelen
Jul 04, 2023Platinum Contributor
ColSaxena Not sure what you have in mind and how this should send an SMS. But the formula returns a text string like C2&D2&E2&F2" if the date in is not equal to today's date. In case you thought of concatenating the contents of those four cells, remove the quote marks.
And if A2 contains todays date, the result will be 0.
ColSaxena
Jul 05, 2023Copper Contributor
Thanks dear Eekelen,
I actually want the entire Row contents of chosen(current) date to be sent by
SMS to my own phone.
I alsowish to know how to enter/ provide my own phone number in
this file, and schedule it for daily checking.
I found an Ad In called Ëxcel To SMS"on"the net, and downloaded it.
But, it is not activated on my Excel program/ sheet.
Could you please guide me further/
Regards,
Col Saxena
I actually want the entire Row contents of chosen(current) date to be sent by
SMS to my own phone.
I alsowish to know how to enter/ provide my own phone number in
this file, and schedule it for daily checking.
I found an Ad In called Ëxcel To SMS"on"the net, and downloaded it.
But, it is not activated on my Excel program/ sheet.
Could you please guide me further/
Regards,
Col Saxena