Site icon Tiller

3 Easy Ways to Timestamp Google Sheets

how to time stamp in google sheets

Time-stamping your Google Sheets can allow you to keep a record of when data is created or deleted in your spreadsheet.

Here are three ways you can use timestamps to keep everything organized in your spreadsheets.

Timestamp Method 1

Using the built-in shortcuts

If you want to insert timestamps in some places in a spreadsheet, using the keyboard shortcut is the easiest and the simplest way to do it.

Shortcuts for PC:

Shortcuts for Mac:

Using the built-in formulae

You can use some built-in formulae into Google Sheets to timestamp your spreadsheet, however, it is important to note that these formulae are not static.

Therefore, the timestamp entered through these formulae will change every time you enter information or make a change in your spreadsheet.

=TODAY()

=NOW()

Timestamp Method 2

Using an IFS statement to automatically timestamp cells

In order to automatically timestamp in Google Sheets when information is entered, we need to use an IFS formula with a circular reference which requires a setting that is usually disabled as a pre-set.

Follow the following steps to see how you can timestamp the information in your spreadsheets using an IFS statement.

Step 1: Resolving the iterative calculation

Step 2: Formatting the timestamp column

Step 3: Using the IFS statement to timestamp

=IFS(A2="","",B2="",NOW(),TRUE,B2)

Time-stamp Method 3

Timestamp using a script editor

function onEdit() {

var s = SpreadsheetApp.getActiveSheet();

if( s.getName() == "Sheet1" ) { //checks that we're on the correct sheet

var r = s.getActiveCell();

if( r.getColumn() == 1 ) { //checks the column

var nextCell = r.offset(0, 1);

if( nextCell.getValue() === '' ) //is empty?

nextCell.setValue(new Date());

}

}

}

References

Exit mobile version