-
Summary Sheet & Filter based on Form Responses with Multi-Select Dropdown
Hi all! Hoping for some assistance with a summary formula pulling in criteria from a multi-select dropdown response form... I have a dashboard that has a form embedded in it to allow the user to enter their desired criteria (see below screenshot) and then the bottom of the dashboard pulls in the metrics using the form…
-
Average of Column
Hello! I was wondering if anyone knew of a way to get an average of a column. I know we can get an average of a specific range in a column, however this sheet I'm working on is a survey and there will be ongoing entries. If possible I just want to get the average of the whole column so I don't have to come back and update.…
-
Summing Costs under a child row while meeting criteria
I would like to sum costs as I receive invoices from my vendors for the current year, cross referencing another sheet. I cannot get the formula to calculate for the child row. Can someone steer me in the right direction, please?
-
Sumifs & multi-select dropdown referencing other sheet
I am attempting to get a sum of one column in another sheet if it has the field(s) in the drop down plus a specific branch. I have tried so many variations at this point that I have confused myself. I need some fresh more experienced eyes I think. Current Formula: =SUMIFS({Helper HC}, {Helper Branch}, Branch2, {Helper…
-
Convert to Column Formula option is missing from my menu
Hi, I'm the Admin of this sheet, but when I right click on the Formula column, I don't see the option to 'Convert to Column Formula' in the menu. Am I missing something?
-
Help with SUMIFS formula
Hi All The below formula is is returning incorrect argument and i can't figure out why =SUMIFS([Column10]@row :[Column14]@row , [Column10]4, [Today's year]#, [Column10]3, ">=1", [Column14]3, "<=6") I would be very grateful for your help as I appear to be missing something simple?
-
How to calculate sumifs across multiple columns
Hello community! I am trying to build a summary worksheet to get an overview of all the meeting categories but my raw data has multiple data columns and the formula I am using comes up as an error Summary sheet Raw data I need to get a total sum from both "no. of meetings chaired by CPO" and "no. of meeting attended as a…
-
My IF Formula only works in certain cells in my grid
I have a formula in my sheet that sums the hours by project, phase and category. Ie for a row with task 1 I get the sum of (1) total hours logged on timesheets, (2) Design Engineer Hours (2) Senior Design Engineer Hours, and (3) Principal Hours. The formulas are as follows: Total Hours: =IF([Budget:]@row > 0, SUMIFS({TS…
-
SHow Availability based on Bookings
Hi I have two sheets, the primary is the booking sheet that has the event dates both start and end date, venue, client details etc. This would be my reference sheet. I have created another sheet that shows the availability of all the venues based on confirmed bookings per venue this is my Availability Sheet. Teh venue in…
-
highlight duplicate cells in each row
In a sheet, I want to auto highlight duplicates in a row so that it looks like the example below where I manually highlighted the duplicates. I want each row to be considered on it's own and highlight the cells in the columns that are duplicates. There are consistently two sets in each row. I don't want to remove them,…