Hello.

I have a worksheet that asks a series of questions. If the answers to these questions result in an Action Item for the project, that item prefills into a cell on a different worksheet.

For the cells that have the Action Item prefill, I'd like to automatically add the date to indicate when the item was "logged". I can get various formats to throw the date in - but, it appears whether the previous cell has prefilled or not.

I guess I'm wondering if the formula in the column that prefills with the action item is causing the cell to NOT appear as blank?

These are the formulas I've tried:
=IF(ISBLANK(A8)," ",TODAY())
=IF(ISTEXT(A8),TODAY()," ")

Also curious if I ever get this thing to work, will the date automatically change to today's date everytime the book is open?
If answer to this is Yes - nevermind above!

Thank you.... and, I do not do VBA or Macros (yet) - so, if you have a solution with one of these - don't go there please!

Thank you!
Carol