-
Help with SUMIF formula
Hi everyone, Can you help me to figure out what is the correct formula to use in this case? I want to sum only the rows that have the following criteria: "Projected" or "General Foreman", or "Foreman". I don't want to sum up the other rows. The formula I was using to sum only projected was this one: =SUMIFS([Mon, 17,…
-
Gantt Chart Shows Completion Bar but not number
I am trying to have my gantt chart show the visible %complete in number form rather than having the bar go then %length as it is much harder to determine how far along it is for shorter tasks. I was wondering if there was a way to have both, as I would like to have it be easily scanned
-
Formula for Quater Dates?
Hello there, I've already built a formula out so that it includes the Quarter and fiscal year, and it works great, however I was wondering if it is possible to make this formula include the extra 5 days of each overlapping quarter? I have no idea how to incorporate this into my working formula however. Any help would be…
-
Formula Using OR - multiple sheets
Hello - I am using INDEX/MATCH formula to pull dates into a sheet. One particular column is different because the dates can be in one of 2 sheets. What would be the correct formula? Current formula =INDEX({3.1 Launched Apps Range 5}, MATCH([Content Name]@row, {3.1 Launched Apps Range 4}, 0)
-
Formula help
hey guys, i need some help creating a formula that will pull through the amount of type A i have delivered month. Thanks in advance, Katie
-
Formula Help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market) I thought it would be something like, but neither are working =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT",…
-
Trying to return a value using if and statements but get Unparseable so Help?
=IF(AND([Due date 2023]@row > TODAY(), ISBLANK[Completed 2023]@row), "yes", BLANK) This is the formula which I think is pretty simple but I'm trying to get a yes if the date from due date column is greater than today and information has not been submitted in the completed column. Feedback is appreciated
-
IFERROR(AVERAGEIF(REFERENCE ANOTHER SHEET
Hi all, Looking for some help on a formula that I keep getting an error. I am looking to populate the average % into a breakout summary sheet by referencing multiple columns from the master sheet, but only if the Master QTR column contains a specific quarter (i.e. Q1). I was able to figure out how to populate the average…
-
Help with Formula Vlookup, collect, if?
Not sure if this is possible but I have a sheet to track monthly billing and another sheet to forecast milestone completions. On the monthly billing sheets I want it to look at the milestone forecasting sheet and if a milestone is forecasted to complete in a month add a billings to the billing sheet. Billing sheet looks…
-
How do you calculate an average on a column that also contains "#Invalid Data Type" in some cells??
I have a column of numbers (days duration) between two date columns but, in many cases, one of the dates may be missing which gives me an #Invalid Data Type entry in the column where I am averaging the days duration. Attempting to average the column, I don't know the syntax to skip over the #Invalid Data Type cells to only…