How to pull the top row only to sheet summary

Dan1976

What is the best formula to pull the top row only from the sheet I am in to the sheet summary fields?

Paul Newcome

I would suggest a basic INDEX function with the number 1 hard coded into the row indicator portion of the function.

=INDEX([Column Name]:[Column Name], 1)

Dan1976

Thanks Paul, if I wanted to always pull the latest modified row into the sheet summary, what would that formula look like?

Thanks again

Paul Newcome

You would use an INDEX/MATCH to match on the MAX of the Modified column.

=INDEX({Column To Pull}, MATCH(MAX(Modified:Modified), Modified:Modified, 0))

Dan1976

Hi Paul, I used the =INDEX([Column Name]:[Column Name], 1) and worked fine for all the fields except when when I tried to pull a 'Date only' column into the sheet summary it shows: #INVALID COLUMN VALUE

Any ideas?

Thanks

Paul Newcome

Make sure the sheet summary field is set as a date type field.