-
How can I work around the Formula Cell Reference Limit?
Hi, I'm getting the below error message. My needs are too complicated to convert any of the formulas to automations and I'm not sure how to simplify. Here is essentially what I am trying to do - every row is a different item and columns A, B, C, and D contain fabric codes. In columns A1 and A2 (and B1, B2, C1, etc.) I need…
-
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
