Thank you, that worked perfectly 👊 On Mon, Aug 1, 2022, 7:16 PM remo <[email protected]> wrote:
> Hi Mike > > You can try this formula in E14 > > =if(not(isblank(e13)),today(),"") > > On Monday, August 1, 2022 at 6:41:36 PM UTC-7 Mike C wrote: > >> Hello group, I'm seriously a beginner beginner , anyway I have a cell >> that I want the date (todays date) to appear when I fill another cell with >> text, in this case a address. so I want E14 to automate todays date when I >> put a address in E13, any help is appreciated. > > -- > You received this message because you are subscribed to the Google Groups > "Google Spreadsheets API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/google-spreadsheets-api/ae7eb6ce-c1e0-4763-881d-50e3b632cb8cn%40googlegroups.com > <https://groups.google.com/d/msgid/google-spreadsheets-api/ae7eb6ce-c1e0-4763-881d-50e3b632cb8cn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/CAHhv36fpvkdDRmDn5iY7_JnOBpauL2d-o4huhD5P-7Gn1SJiGg%40mail.gmail.com.
