I’m creating a Coda doc in order to control the versions of the way standards are worded. There are “Standards” and then “sub-standards”. The wording for each standard is contained at the sub-standard level. When a sub-standard wording changes I duplicate the row, change the wording, then change the version number. What I want to do is find a way to see only the latest version of each sub-standard. That means for Standard A there are going to be, say, 9 sub-standards. 3 of those sub-standards are v1, 3 are v2 and 3 are v3. I want to somehow see only the latest version of each standard. So I only want to see v3 of Standard A. Meanwhile, Standard B only has standards at version 1. So I want to see those too (meaning I can’t just filter by version number because some standards have changed while others haven’t).
Hopefully this makes some kind of sense. i’d appreciate the help!