Time stamp and email

[Countryboy69]

I need a formula that when I enter a number on a designated cell it will populate it to the first column and date/time stamp it. Also need a formula that at 7 p.m. it will email the sheet to a certain email address. It would also be nice if it could clear its self every night. Btw cant be macros because I'll be using this on a phone. Hope someone can help me thanks in advance

 

[Fluff]

A formula cannot email a sheet, you need VBA for that.
Also if you want the time stamp set in stone, so that it doesn't change, you will need VBA.

 

[Countryboy69]

Can I do all that from a phone? I was under the impression it wouldn't run macros or vba on a phone.

 

[Fluff]

I've never used Excel on a mobile, so not sure. But from what I can find, the answer seems to be No.