Only display Last Version

Topic Labels: Formulas
671 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello All! Not sure I should ask this question in Formulas. On a list of multiple versions of a same item I’d like to only display the last one.
Here is what I have:

Here what I wish to obtain:

Thanks in advance!

1 Reply 1

Sounds like you need two tables: one for Items and one for Versions.

Items would have to records: ABC_ABV and ABC_ACB. Each of those records would be linked to all the associated versions. Then from there you could use rollups/lookups to display in the Items table the {Version Name} of the most recent version. Refer to this thread for an example