How to Create a Checkbox Timestamps Project Tracker
Emma Chieppor
20 steps
2 minutes
Microsoft Excel
1
Click here
2
Type '=IFS(E4=FALSE,"",F4="",NOW(),TRUE,F4)'
3
Press [[Return]]
4
Press [[Return]]
5
Click here
6
Double-click here
7
Click here
8
Click here
9
Click here
10
Click here
11
Click here
12
Click here
13
Click "New Rule..."
14
Click here
15
Click here and enter '=$E4=TRUE'
16
Click here
17
Click here
18
Click here
19
Click "OK"
20
Done!
How to Create a Checkbox Timestamps Project Tracker
Emma Chieppor
20 steps
2 minutes
Microsoft Excel
1
Click here
2
Type '=IFS(E4=FALSE,"",F4="",NOW(),TRUE,F4)'
3
Press [[Return]]
4
Press [[Return]]
5
Click here
6
Double-click here
7
Click here
8
Click here
9
Click here
10
Click here
11
Click here
12
Click here
13
Click "New Rule..."
14
Click here
15
Click here and enter '=$E4=TRUE'
16
Click here
17
Click here
18
Click here
19
Click "OK"
20
Done!