-
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…
-
A cross reference formula that was working before suddenly stopped working
I maintain a weekly project tracking system across two sheets: Sheet 1 (Project Status): Contains detailed project status updates Adds 20 new rows each week (one per project) Includes a 'Snapshot Date' column to identify the week Sheet 2 (Status Summary): Tracks project status counts (on-track/off-track) by week Previously…
-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…
-
How can I edit a formula reference across all projects using Global Update?
I just did a global update to add two new columns to one of the sheets in my projects. Both columns included a vlookup. The columns came through fine, but the formulas aren't working because I used the reference "New Individual Rates Range 1" which already existed in my sheet. The original reference only evaluated the…