Latest Revision - without pulling Revision History
I could use some help problem solving this. I have a smartsheet tracking revision number and date for about 240 rows of submittals.
I'm trying to come up with a formula that will tell me the latest revision for each row and will auto-update as new revisions are added.
The goal being to have a clean print out which would show Drawing Package, Description, latest revision # & date for each row, without showing the entire revision history. I think I can figure out how to pull the date in once I get this initial equation, so no need to worry about that for now.
Using the above screenshot as an example, I would want it to pull:
C1.03 - Rev 1
C2.00 - Rev 0
C2.01 - Rev 2
Currently, I'm trying to pull in the information based on which of the checkmarks are selected but not getting too far. We are open to changing how the information is entered if you think of something that would make more sense than using checkmarks.
Thanks for your help!