How to pull the top row only to sheet summary
What is the best formula to pull the top row only from the sheet I am in to the sheet summary fields?
Answers
-
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)
-
Thanks Paul, if I wanted to always pull the latest modified row into the sheet summary, what would that formula look like?
Thanks again
-
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))
-
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
-
Make sure the sheet summary field is set as a date type field.