Date only to appear if text is added to previous cell

[Guest]

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

 

[Tom Ogilvy]

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

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!

 

[Guest]

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

Hello.

these questions result in an Action Item for the project, that item prefills
into a cell on a different worksheet.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.

=IF(ISBLANK(A8)," ",TODAY())
=IF(ISTEXT(A8),TODAY()," ")

change to today's date everytime the book is open?