gpt-3.5-turbo-0613· OpenAI WildChat-4.8M (AI2)
google sheet function to timestamp a cell if the adjacent cell is true
- User
google sheet function to timestamp a cell if the adjacent cell is true
- Assistant
You can use the
IFfunction along with theNOWfunction 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
NOWfunction. 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.