I thought I would post my issue here since the SS community has been so great at helping solve my other SmartSheet dilemmas!
For each project that the PMO oversees, we have a sheet with a single row of project health metadata. On the first of each month a workflow runs against the metadata sheet and copies the row to a “scorecard” sheet so we have a static “image” of the data. So at the end of the year, it is possible to have up to 12 rows in the scorecard sheet. The period/month and workflow run dates are recorded each month (example below).
I want to create a report from the scorecard sheet, but only show the most recent 3 months. In the example below, I'd like to only show the data from months 2, 3 and 4. And in month 6, only show data from periods 4,5 and 6.
Would the LARGE function work if I created a helper row and scanned the period column and added some text in the helper column for the 3 largest periods? And what would the formula look like? I have never used LARGE.
As always, any advice or help would be appreciated.
