Skip to content
The Chat Archive
gpt-3.5-turbo-0613· OpenAI WildChat-4.8M (AI2)

google sheet function to timestamp a cell if the adjacent cell is true

  1. User

    google sheet function to timestamp a cell if the adjacent cell is true

  2. Assistant

    You can use the IF function along with the NOW function to timestamp a cell if the adjacent cell is true. Here's an example:

    =IF(A1=true, NOW(), "")
    

    In this example, if the value in cell A1 is true, it will insert the current timestamp using the NOW function. If it is not true, it will leave the cell blank.

    Keep in mind that the timestamp will keep updating every time the sheet recalculates. If you want to have a static timestamp that doesn't update, you can use a script or a combination of functions.