Skip to content
Archiving Dates
Once in a while you want to keep track of the dates and the users that confirmed something. Keeping track of dates on row level is a practical application of ModifyRows(). However if you simply use the basic formula, it looks ugly with a comma in front of the first item.
Below the ugly and three correct formula variations, up to you how you like it. However as you can see, the application of the The Last only works well with the The Straight Variation
By using IfBlank(List()) you avoid the ugly comma in front of an item.
Archiving Dates
Time
ConfirmedBy
the Ugly
The Straight
LeftToRight
RightToLeft
The Last
8/26/2021 4:45:20 PM
8/26/2021 4:45:19 PM
8/26/2021 4:45:15 PM
8/26/2021 4:45:14 PM
8/26/2021 4:45:12 PM
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
Click me
Click me
Click me
Click me
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
→
8/26/2021 4:45:20 PM
8/26/2021 4:45:19 PM
8/26/2021 4:45:15 PM
8/26/2021 4:45:14 PM
8/26/2021 4:45:12 PM
8/26/2021 4:50:05 PM
8/26/2021 4:50:08 PM
8/26/2021 4:50:08 PM
8/26/2021 4:50:09 PM
8/26/2021 4:50:09 PM
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
Click me
Click me
Click me
Click me
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
→
8/26/2021 4:50:05 PM
8/26/2021 4:50:08 PM
8/26/2021 4:50:08 PM
8/26/2021 4:50:09 PM
8/26/2021 4:50:09 PM
8/26/2021 4:50:13 PM
8/26/2021 4:50:15 PM
8/26/2021 4:50:15 PM
8/26/2021 4:50:15 PM
8/26/2021 4:50:16 PM
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
@Christiaan Huizer
Click me
Click me
Click me
Click me
@Christiaan Huizer
→
8/26/2021 4:50:16 PM
8/26/2021 4:55:50 PM
8/26/2021 4:55:52 PM
@Christiaan Huizer
@Christiaan Huizer
Click me
Click me
Click me
Click me
@Christiaan Huizer
→
8/26/2021 4:55:52 PM
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.