質問する

HamMan's profile - activity

2018-09-24 06:34:47 +0200 バッジを受け取った  体系学者
2014-05-19 07:48:42 +0200 バッジを受け取った  有名な質問 (source)
2014-02-24 02:51:18 +0200 コメント付き回答 Static now() function for a log.

Jens answer gives an error notice, not the NOW() result. Getting the NOW() result in column A as a result of a condition in column B is not difficult. A simple IF() functions does nicely. The problem is, the NOW() result is not static. That is, for example, if a row in Column A should receive the result of NOW() as a condition of the presence of a row entry in column B, the result is indeed the value of NOW(). Good enough so far. HOWEVER, subsequent rows when they are entered change the value of ALL the previous entries in column A to the value of the newest NOW() result. A new line entry causes ALL NOW() results to change to the same value. That means that it looks like the whole log was entered at the same time-- the time given by the last row. Is there a ... (more)

2014-02-21 13:52:30 +0200 バッジを受け取った  卓越した質問 (source)
2014-02-21 11:14:02 +0200 質問に回答する Static now() function for a log.

Thank you for that answer. I was unaware of that CTR;-SHIFT-; shortcut.

I should have been a bit more specific as to the function needed. It would be time-saving in a fast moving environment to have a time stamp in a cell upon certain text being entered into an adjacent cell. Thus, as the log becomes filled in with text, each line is stamped with the current time automatically with no other interaction. The now() function would be perfect if there were an option to have it only update upon first line creation. As it is, using an if() function, I can get the now() function to work; however, when subsequent lines are entered ALL of the previous time-stamps are updated to reflect the time of the last created line. It won't work.

Is there a way to use the CTRL-SHIFT-; shortcut in an expression such as =if(b2>0,CTRL-SHIFT-;,"") ?

2014-02-12 00:33:49 +0200 バッジを受け取った  人気の質問 (source)
2014-02-10 18:29:39 +0200 質問をする Static now() function for a log.

I'm creating a log that needs a time-stamp on each line as the line is created. I tried the now() function which puts a time-stamp on the line created, however, the time-stamps of all other lines are updated to the current now() time of the new line when a new line is created.

Need a "static now()" function that updates only on creation.