Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Only display Last Version

Topic Labels: Formulas
217 1
Showing results for 
Search instead for 
Did you mean: 

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