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 google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/ae7eb6ce-c1e0-4763-881d-50e3b632cb8cn%40googlegroups.com.