Select Current Data Submitted per Project in ONE collector sheet

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?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!