-
Vlookup as "Column Formula" is not working properly
Hello! I was hoping someone can please point me in the right direction on this one. I created a Vlookup that will compare an ID number on a sheet that users will fill out via form, and return the due date listed on a different spreadsheet. The formula I created worked on the first row. =VLOOKUP([Context ID]@row, {Due…
-
AVG Collect Formula Help
I am looking to add to the formula so that if {APD CI Tracker Range 5}, ="Pilot/ Implemented" the Dashboard reads "Pilot" OR if {APD CI Tracker Range 5}, ="Monitor/ Check" the dashboard reads "Monitor" and if {APD CI Tracker Range 5} is not Working, Pilot/ Implemented, or Monitor/ Check the Dashboard reads 0 Current…
-
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…
