Dynamic View and "Group By"

Yvonne.Clavin

Hi there

I have a large sheet that i have used the "group By" function to collate by a particular column fields - when i add a dynamic view to make this sheet editable on a Dashboard it loses the groups and reverts to an ungrouped Sheet view - any thoughts ? Help appreciated :-) Trying to reduce clicks one day at a time :-)😊

Soumitra Bhowmick

I am not aware of any wayout of this. Group By just a view in Sheet, but the underlying data is still ona row level which gets passed to Dynamic View.

One possible way out that I can think of is, create a helper column to identify the header level rows. Then create a filter in the sheet to filter only those rows and use the same filter in Dynamic view to show only top level rows.