Skip to content
Gallery
Copy of Playground Doc - [SHARED]
About
Table Sort Control
One Click Timer
Time in 1/100 second
Button to log time
Click Thru Button
Working Days Remaining
Working Hours
Delete Empty Rows
Multiple Ranked Lists
Three Most Recent Rows
Search with Regex
Search with Clear Search Button
Search with Accuracy Meter
Find Tags in a Post
Language Translations
Split First and Last Names
Mark Row as Opened
Project Tasks for CAD
Random Numbers
In List 1 not in List 2
Custom Units
Reverse a String or Number
Barcodes / Check Digits
Luhn Algorithm
vCard QR Code
Scientific Notation Display
Lookup Column Schema
Price by Date
Time Zones
Pixel Image
Share
Explore
Link to page

Three Most Recent Rows

From the community post:
Show only the 3 most recently added rows that match a certain value
⁠
⁠

Customer
⁠
⁠

Three Most Recent Rows
Customer
Data Modified
Rank
Rank List
A
9/11/2018, 5:57 AM
1
149
A
9/11/2018, 5:57 AM
4
149
A
9/11/2018, 5:49 AM
9
149
No results from filter
3
Count
⁠

Three Most Recent Rows - Full Data Table
Customer
Data Modified
A
9/11/2018, 5:47 AM
B
9/11/2018, 5:48 AM
C
9/11/2018, 5:48 AM
A
9/11/2018, 5:49 AM
B
9/11/2018, 5:49 AM
C
9/11/2018, 5:49 AM
A
9/11/2018, 5:49 AM
C
9/11/2018, 5:50 AM
B
9/11/2018, 5:50 AM
A
9/11/2018, 5:57 AM
B
9/11/2018, 5:57 AM
C
9/11/2018, 5:57 AM
A
9/11/2018, 5:57 AM
B
9/11/2018, 5:57 AM
C
9/11/2018, 5:57 AM
There are no rows in this table
15
Count
⁠

Customer control selector is named: SelectCustomer

[Data Modified] Formula: Modified(thisRow)

[Rank] Formula: Rank(thisRow.[Data Modified],thisTable.[Data Modified])

[Rank List] Forumula: Filter(thisTable,Customer=SelectCustomer).Rank.Sort().Slice(1,3)

Table Filter: (Customer=SelectCustomer) AND Rank.Contains([Rank List])


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.