-
Sum up values with #NO MATCH error
HI All, Some of the cells that I want to sum up are a "#NO MATCH" which is fine as those values are based on other formulas and there might be no value for them. Now, trying =SUM(IFERROR(Cellsrange,0)) is not working, its giving me "0" as a result which is incorrect.- see attached. Please help as its really painful doing…
-
Countifs Reference Another Sheet - Help
This is the formula I am trying to use with reference to another sheet. Range 5 I want to only count if ticket status is "resolved" and Range 6 if in the month of Dec 2023. Error "Unparsable". =COUNTIFS({Field EDI Request Sheet Range 5}, [TICKET STATUS], "RESOLVED", [{Field EDI Request Sheet Range 6}, (LAST STATUS DATE},…
-
Need to identify the current month plus the last 7 days of the prior month
Hi there, I have a helper column that checks the "Current Month" check box if the date is within the current month: I used this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) The business is now asking to identify when a date is in the current month or in the last 7 days of the previous month. For example, this month…
-
Calculate count based on certain criteria.
Using a helper column to either return a 1 based on certain criteria or greater than 1 based on countif. Then conditional formatting to highlight those that are >1 Current formula that works (partially): =IF(Sit@row = "NA", 1, COUNTIFS([School Name]:[School Name], [School Name]@row, Sit:Sit, Sit@row)) Returns a 1 if the…
-
How to pull data from one sheet column to another sheet column
I need a formula that will extract all data from the column A in sheet A and auto fill it in column B in sheet B when added in the source sheet. Sheet A will have different columns and info than in sheet B, needed only the auto pulling of the data from this one column.
-
Formula Check Box
Hi There, I need help with implementing "Checked" vs "unchecked" symbol into my formula. Online I saw " Checked" and "Unchecked" and that didn't work for me. My formula : =IF([Founder?]@row = "", [First Name]@row + " " + [Last Name]@row + " is a founder of " + [Name of Company]@row + ".", IF([Founder?]@row = "", [First…
-
Quick SUMIFS question - Additional Criteria is Date
Hello, I have a quick question for the formula gurus. I have two sheets, a Roster and Data sheet. My roster sheet is where I want to show the data and the Data sheet is just a collection form. My goal is to display a point total that only pulls points from the last two weeks (14 days). So this is my data sheet. As we can…
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
SUMIFS with date range formula question
Greetings, I'm attempting to sum the number of project management hours for the project managers in my function for given points in time to generate a capacity forecast for 2024. I'm currently building a sheet to depict capacity every 2 weeks based on if a date falls between project start and end that will be built off a…