Microsoft Excel

How to Automatically Add a Timestamp to Checked Checkbox

This guide demonstrates how to efficiently navigate the spreadsheet interface to manage and verify submission statuses. Follow these steps to correctly apply checkboxes and track your data entries in the submission tracker.

Emma Chieppor
9 steps
2 minutes

Microsoft Excel

1

Click "D4"

Action screenshot

2

Enter this formula:\ [[=IF(C4=TRUE,IF(D4="",UPPER(TEXT(NOW(),"mm/d/yy | h:mm AM/PM | dddd")),D4),"")]]

Action screenshot

3

Click "D4"

Action screenshot

4

Fill the formula down the column.

Action screenshot

5

Spreadsheet Completed.

Action screenshot

6

1 Check a checkbox to test if it’s working.

Action screenshot

7

2 Check a checkbox to test if it’s working.

Action screenshot

8

3 Check a checkbox to test if it’s working.

Action screenshot

9

Done!