Hi all,
I am working on an app build with Glide and attempting to create a clock-in and clock-out timesheet. However, I am having trouble with a formula.
I want to sum the total duration of hours (sheet 2, column E) based on the job name in (sheet 1, Column A). The formula should do the following:
1- Compare column A on sheet 1 with column A on sheet 2
2- If the text in any row on sheet 1 column A, matches the text in sheet 2 column A
3- Sum the corresponding row values in sheet 2 column E
the formula I am currently using is:
=sumif(Timesheet!A:A, Project!A:A,Timesheet!E:E)
This formula works appropriately, however... I want to add ArrayFormula to the beginning which does not work with SumIf.
I believe I need to use an If, Then statement, however, am not sure how to write that.
Any help would be appreciated.
Thank you!
Bookmarks