-
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…
-
Creating a formula for metrics sheet with multi-selection dropdown
Hi all, I am creating a metrics sheet, and am having trouble creating a formula to count how many cells of a specific variable (call it "Zone") has multiple selections. I've already counted the ones where only one zone is selected but, but am missing the counts for those remaining with multiple zones selected (can call…
-
Formula to indicate which quarter the Project's end date is in ...
… I had a formula that was working before July 1, but now "Incorrect Argument Set". :( The purpose of this formula is to indicate where the project's end date is in the Past Quarter (one quarter behind the current quarter), the Current Quarter (the end date occurs within the current quarter we're in), and the Next Quarter…
-
Copying a Checkmark Field from one to another on the same sheet.
Hello, I have a process set up where I pull data in from another sheet, and then I have a handful of Columns with formulas that will fill with a Check or Uncheck based on the information in the data that was pulled in. My goal was to be able to use these Checkbox columns to track processes, but since the columns are locked…
-
Formula Question - Finding Data
Hello I have a sheet with three columns and the primary which is not used, 2 Date columns and 1 Dropdown. The Dropdown has 5 tasks in it and the date columns are for start and end date. The Task column will have one to many of the same tasks but all with different start and end dates. For each row I need to find the next…