Timestamp - No VBA

[Newbienew]

Good day Pros,

I was doing some research on a static timestamp as I was trying to apply it to a project I was working on. Is there a way to make a formula static? I have used =IF(A1<>"", IF(B1="", NOW(), B1), "") and I have used a lamda version as well. =lambda(x,y,if(len,x))(now(),b3). In both cases, no matter what I do, all the cells that have the formula in them update with each entry. Please Help. Thank you

 

[6StringJazzer]

not sure if Teams supports Office Script

Teams is a communication channel and file repository. It doesn't have anything to do directly with Excel. However, I am going to infer that OP's team is using Excel Online to open files that are stored in Teams. (SharePoint is the same way and lot of people talk about "opening a file in SharePoint" when what they are really doing is opening a SharePoint file in Excel Online.)

 

[MARK858]

Teams is a communication channel and file repository.

I know what Teams is but I had no idea how the OP was using Excel with it and was hoping the OP was going to respond with confirmation on exactly what version of Excel they were using (although using Office Script is no more practical for time stamping than doing it manually).

 

[Newbienew]

If iterative calculation doesn't work for you (I won't use it btw) and you can't use VBA (not sure if Teams supports Office Script, but if it does then you would need to run it each time) then the only other option AFAIK is to manually press

Ctrl-Shift + ;

Thank you for your input. I didnt know I could enter the time like that

 

[6StringJazzer]

CTRL + : is the time, and SHIFT + ; gives you the :
so CTRL + SHIFT + ;

Also CTRL + ; is the date