I am trying to generate a workflow that looks...

ux
(Kevin Kelley) #1

I am trying to generate a workflow that looks like the table below. There are more groups below just like the “.Total (2018)”. Is there a way to group a table in a workflow like we do in a table view? Thanks in advance.

(Philip Garrett) #2

@Kevin_Kelley

No. Workflow does not support “group by”.

(Kevin Kelley) #3

Ugh. Ok, thanks for the quick reply.

(Aleksi Alkio) #4

You need to generate it with a suitable QUERY expression in the spreadsheet and then read that table for your template.

(Simon Robinson) #5

Its possible if you always want the workflow to show all the groups.

Otherwise, like @Aleksi_Alkio said, you’ll need to create a table in Sheets or whatever that lays out your data as you want to display it in a workflow or a view.