-
Sheet Formula to reference DataTable
DataTables work well for their limited purpose. However, to analyze the data you must create a limited sheets from the data then analyze that data, even if all you want is a Sum Total. I would be great to be able to use formulas that reference this data, such as: Sumif(s), Countif(s), Index/Match and others.
-
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.…
-
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…
-
Formulaire intelligent
Bonjour, J'utilise un sheet avec 180 colonnes. Dans ces colonnes je renseigne manuellement une valeur "Yes", "No" et "N/A". Dans un autre sheet, je souhaite créer un formulaire "intelligent". Lorsque j'indique un critère particulier "ID" par exemple, présent sur les deux sheets, je souhaite que le formulaire m'affiche…
-
Formula not working - correctly
I tried applying a formula, but the results aren’t coming out correctly. For example, the headset count is showing as 6, whereas there are actually only 3 headsets. I suspect the issue is due to multiple items being listed in a single cell (e.g., "Headset, Keyboard"). Could someone please confirm if the formula supports…
-
Help w/ Countifs for multi-select drop down field
Hi, I am trying to use the following countif on a RAID log where the 'impacted validation report' (RAID Log - Template Range 1) is a multi-select drop down field. I cannot get the formula to return anything but 0 when I know there are outstanding issues in each different status. This is the raid log and formula. Each…
-
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
-
How can I create an autonumber field that only increases when the column "Hierarchy" = 0?
What I have tried so far but is not working: =IF([Hierarchy] = 0, MAX((IF([@[Hierarchy]] = 0, [@[AutoNumber]]))) + 1, "") =IF([Hierarchy]@row = 0, COUNTIFS([Hierarchy]:[Hierarchy], 0, ROW([Hierarchy])@row , "<=" & ROW()), "") =IF([Hierarchy@row ] = 0, COUNTA([Hierarchy@row ]) + 1, "")
-
Summary Sheet Formula - conditions
Hi Wizards, I use a lot of formula including summary sheet formula for use in dashboards. SUMIF and CountIF are great but here is my problem (bear with the long explanation) 3 departments fill in a daily form and select Area (Stoke, CC or Transport) and then provide 4 or 5 pieces of information all through a form. This…