One of our support services has created a single collector sheet to collect responses via a form across multiple projects. When project information changes, responses are resubmitted for that project, adding another line item for that project in the collector sheet. We need to find a solution that will collect the most current row for each project listed on this one collector sheet, and either 1) input the current data for each project in a summary field so we can pull the data from the sheet summary or 2) create a collector report of current data only to create a metric widget on a dashboard.
We have created a check box helper column, =IF(Submitted@row = MAX(Submitted:Submitted), 1)
But it (obviously) will only find the most current line, not the most current line of each project. I need it to do that for EACH project listed on the sheet. Is this possible with some version of a Max/Collect syntax?
