Edit history and version control in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to show the last edit time of the current sheet.

Google Sheets

=NOW() - [1]

Drag options to blanks, or click blank then click option'

A0

B1

CTODAY()

DLASTEDIT()

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 subtracts one day, which changes the time.

Using TODAY() returns only the date, not time.

LASTEDIT() is not a valid function.

The NOW() function returns the current date and time. Subtracting 0 keeps it unchanged, which can be used to refresh the timestamp.

2fill in blank

medium

Complete the formula to get the version number of the current Google Sheet.

Google Sheets

=VERSION() [1] 1

Drag options to blanks, or click blank then click option'

A+

B*

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus adds to the version number incorrectly.

Multiplying or dividing does not make sense here.

The VERSION() function returns the version number. Subtracting 1 adjusts the version count as needed.

3fill in blank

hard

Fix the error in the formula to show the last editor's email address.

Google Sheets

=GETLASTEDITEDBY([1])

Drag options to blanks, or click blank then click option'

ASheet1

B1

CNOW()

DA1

Attempts:

3 left

💡 Hint

Common Mistakes

Passing a cell reference or sheet name causes errors.

Using NOW() is not valid here.

The GETLASTEDITEDBY() function requires the version number as a parameter, which is a number like 1.

4fill in blank

hard

Fill both blanks to create a formula that shows the timestamp of the last edit and the editor's email.

Google Sheets

=CONCATENATE(TEXT(NOW() - [1], "yyyy-mm-dd hh:mm"), " by ", [2])

Drag options to blanks, or click blank then click option'

A0

BGETLASTEDITEDBY(1)

CGETLASTEDITEDBY(2)

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 in the first blank subtracts a day.

Using GETLASTEDITEDBY(2) may not return the latest editor.

Subtracting 0 keeps the current time. GETLASTEDITEDBY(1) returns the last editor's email.

5fill in blank

hard

Fill all three blanks to create a formula that lists editors for the last three versions.

Google Sheets

=ARRAYFORMULA([1](1, 2, 3), [2](1, 2, 3), [3](1, 2, 3))

Drag options to blanks, or click blank then click option'

AGETLASTEDITEDBY

BNOW

CVERSION

DTEXT

Attempts:

3 left

💡 Hint

Common Mistakes

Using NOW, VERSION, or TEXT functions here is incorrect.

Mixing different functions causes errors.

The GETLASTEDITEDBY function called with versions 1, 2, and 3 returns the editors for those versions.