asked on August 17, 2018

I can pull info from a collection using using the index formula. This goes into a field outside the collection. How do I reference the last item?  The number of rows fluctuate.

Here is the formula I've tested to see if it would work...=INDEX(Comments.ExplanationComments,1).  This does populate the field with the first item, but I'm not sure how to reference the last item. 

 

0 0