Well, I didn’t want to go into too much detail so as not to be confused …
I will try to be synthetic.
I have 2 sheets to manage climbing equipment.
1 sheet with all of the material, each material having a unique identifier: material
1 other sheet linked to a form which serves as a history for the verification. Historic
In the sheet which centralizes all the equipment, I made a relation thanks to the glide editor with the “historic” file and a rollup to determine the date of the last verification (special value in form > date) for each equipment of the material file.
Only, this value (last check) does not appear in my Gsheets because it remains in the Glide editor. I want to export to Word with this “material” sheet to automatically generate 1 sheet per material … and I need this date of last verification. It is present under glide but not in Gsheets … hence my first remark.
I explored the arrayformula function to go only through sheets, but I can’t get it to work with the maxif function. (maximum dates for each material identifier)
I hope I have been clear because it is not easy to explain everything, the project is quite complex …