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

Today() is volatile and will update on each recalculation, so the date won't
be static.

You can enter a static date with Ctrl+; (time with Ctrl+Shift+;)

You can use intentional circular references (which normally cause an error)
to do this with formulas, but then you have to disable such error checking
and this is an application level setting.

--
Regards,
Tom Ogilvy


"Carol" wrote in message
...
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

I pretty much want to do the same thing. When the user of the worksheet we have developed selects a certain thing in one cell, I want to "date and time stamp" when they selected that in another cell. Is there any way to include the static date and time as part of a formula or macro? I tried to record the keystrokes in a macro, but it just recorded the value instead. It would seem to me that there should be some way to put it in an IF statement (i.e. IF C1 = Office, then do a CTRL+; and CTRL+SHIFT+;) But I guess that would be too easy!

Thanks!
Nathan

----- Tom Ogilvy wrote: -----

Today() is volatile and will update on each recalculation, so the date won't
be static.

You can enter a static date with Ctrl+; (time with Ctrl+Shift+;)

You can use intentional circular references (which normally cause an error)
to do this with formulas, but then you have to disable such error checking
and this is an application level setting.

--
Regards,
Tom Ogilvy


"Carol" wrote in message
...
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