nesting & sorting functions in Google sheets

[Ian99099]

I wonder if anyone can help me with the following issues in this spreadsheet please?

https://docs.google.com/spreadsheets...it?usp=sharing

The idea is that on the first sheet is data. The second sheet takes that data and sorts it. It then takes that sorted data and filters it by looking for dates after a date specified in a separate cell. The third tab has a Chart that uses the data collated on the second sheet.

I have 2 issues:

1) is it possible to nest the 2 formulas? (they are highlighted in yellow on the sheet)
2) Can I get the data in the chart to run lower dates to higher dates, left to right? At the moment it runs right to left because I needed to sort the data so the titles are at the top.

Be great to hear any thoughts.

Best Wishes

Ian

[rorya]

Do the names in the first row change? If not, you could simply exclude them from the sort range and add them manually to the chart data sheet, so you can sort ascending.

And yes, you could use the Filter function as the range for the SORT function.

[Ian99099]

Hi Rory

Yes I could manually exclude the titles from the filter before sorting and add them manually to the chart.

I'll give the nesting a go, thanks.

Thanks

Ian

[rorya]

No worries. Just post back if you get stuck.

[Ian99099]

It looked so easy but.....

I can't get the nested formula:

=sort((filter(Data!A:D,Data!D:D>=h1),4,0))

to work.

Any pointers on why would be gratefully received....

[rorya]

Based on your layout, you'd copy the headers over, then use:

=SORT(FILTER(Data!A5:D,Data!D5:D>=H1),4,True)

You've got an extra set of brackets in your formula that are causing the problem, but you also don't need the whole columns.