Hi, I’ve searched around and haven’t found an answer to this, so here’s hoping someone can offer help.
I’m using AirTable to record and invoice hourly work. Among my columns I have
- client (organized in single select dropdown)
- employee (organized in single select dropdown)
- employee hours (organized in a # column)
I need to create a view or a tab in my base that adds all the total hours by client in a way that allows me to add them to a Block so I can create an invoice.
a) On (date) (Steve) worked (3 hours) on (client 1)
b) On (date) (Steve) worked (2 hours) on (client 2)
c) On (date) (Bob) worked (4 hours) on (client 1)
I need to have this formula calculate
Client 1 - 7 hours (sum of records A & C)
Client 2 - 2 hours (record B)
… ideally while filtering by employee and date, but I can figure that part out.
Obviously, organizing a view into “Group By” accomplishes this, but the sums of the Group By fields are not possible to import as a value into a Block.
Anything helps, thank you!