Append rows + sum cells

[Klavs_Buss]

I have following table:

What i would like to do is append rows, which has identical “Tasks” and sum “Cost” for those.

Usually task names could be super unique, so specify their names in formula is no-go. Also Airtable “grouping” functionality is not useful, because afterwards i need to put them in invoice via Page designer. Unfortunately PD don’t provide to group identical columns :frowning:

What you would suggest?
Thank you.

[Elias_Gomez_Sai]

So that is a Tasks table?

Klavs_Buss:

What i would like to do is append rows, which has identical “Tasks” and sum “Cost” for those.

And you want to kind of duplicate a project? I don’t understand your case, can you explain deeper?

[Klavs_Buss]

Here I’ll try to explain my case little deeper. What I try to accomplish is completely automatic invoicing system. Currently I have linked Toggl with Airtable which automatically pulls all my working data entries to AirTable. So every time, i start to work on one task, for example “Design - Logo” on April 26 14:00, it automatically appears in my table. So far so good.

Problem starts when I want those “identical” {Task} sum up in my auto generated invoice (via Page designer). They appear like different tasks.

Instead i would like to group/append them by {Task}. Similar to grouping functionality in table view

As far as i did my research there is no way of appending them in Page designer, so I now searching for way to duplicate all entries to other sheet/tab and group entries by {Task} & summing up {Duration} & {Cost}. So is there any way to do it? Thanks for your help.

[Elias_Gomez_Sai]

You just need to create a Tasks table and convert the field in the TimeEntries table. In the Task table, you create a Rollup that sums the time of all entries for that task.

[Klavs_Buss]

If you thought something like this:

It does not work, as Page designer still separates them.
Even more, it somehow does not want to allow putting task {Name} into Page designer.

I really have tried everything, and it seems only real option that might work is flat converting those entries skipping all the linking part. As soon as i start to link back no original entries, Airtable does separate them.

Can’t believe they haven’t fixed this basic functionality for years.

[Elias_Gomez_Sai]

I think you are invoicing Time Entries instead of Tasks.

[Elias_Gomez_Sai · Accepted solution]

In fact, you have to invoice a Client, I’ve made a mockup:

This morning I’ve replied (with video too) to a very similar thread, but with Invoices table:

Auto tag line items that have been invoiced Ask the community

This is what I’d do: Of course you can add more fields to filter on the Invoicing view: add a ‘Billable’ checkbox indicating which tasks are ready to invoice add a filter bases on a Status field, so InProgress tasks are hidden and so on. The part where I carry on the Client information for the invoice is a bit tricky, but you could do it easier to build if you link a Invoice with a Client (but with one extra step for every invoice).

[Klavs_Buss]

Thanks a lot, it did work. I now have fully funcional invoice. :star_struck: :exploding_head: :pray: