Transferring largest value of children's row
I am trying to report the document review status. As you can see in the picture, I'd like to report the latest version of the comment sheet of every document.
In the picture, for each topic (there are two topics: Gardening and Cooking) there will be many documents. In this example, Gardening has 3 documents : Apple, Blueberry, and Grape.
For each document, there will be many versions as well as the comment sheet version. There isn't any fix pattern on the sequences.
My objective is to report the latest version of comment sheet for every document in the "Latest comment version" column as shown in the picture. When the comment sheet is not yet issued, I want to write R00.
I am still new to smartsheet and kinda lost here. I hope you can help me with this. Thanks.
Help Article Resources
Check out the Formula Handbook template!