-
Index Match Match returning completely wrong values
Hi Team this is the formula =INDEX({Sales and Transfer Calculation _sold}, MATCH(SKU@row, {Sales and Transfer Calculation_SKU}, MATCH([Closing Date Range]@row, {Sales and Transfer Calculation _Date}, 0))) its returning values but not the right ones. Any ideas? thanks in advance Chris
-
Why isn't our column formula updating on its own?
In our column formula, we have a date formula based on TODAY(), however, it does not seem to update automatically when the month changes. How do I get it to update automatically at the beginning of the month?
-
Averageifs with multiple criteria
Hey! I'm trying to return the average of a task that is completed from multiple houses I need to check whether it is the task I am looking for and if it is complete, and then return the average duration for the tasks that follow those criteria If averageif had multiple criteria I could do this easily, but it does not ND is…
-
Count Distinct Collect - Unique Values Several Columns - Help
Hello! I am trying to get the unique number of countries that have a value greater than 0 from a set of columns, the formula works, if I just collect from one column, example below, I get what I want, but if I try to add Carlos's Colum or others to the formula, then it does not work or just returns 0 or 1.…
-
Cross-sheet VLOOKUP maximums
With the new cross-sheet VLOOKUP function, how many VLOOKUP cells can exist in one sheet? Does the limit change if there are both inbound and outbound VLOOKUPS in the same sheet?
-
Return a single text value if either option A or option B from drop down list is selected
Hi there! Looking for help with a formula that will be able to return a single text value "Not Applicable" in Column 2 if either Option A or Option B is selected from a drop down list in Column 1? I think I'll need to use the IF and CONTAINS function but not sure how I might be able to join these two together? Thanks in…
-
Need Help with Approaching Due Date Formula
I have an Approaching Due Date column with the Star checkbox and I want to create a formula that will show the Star if today is between 7 working days in advance of the End Date and the End Date, and the Status is NOT Complete. I also have a column for Past Due with a Red Flag checkbox. I want the Approaching Due Date…
-
COUNTIF's Formula Multiselect dropdown + Status
I'm trying to create a sheet summary for the number of items with a status of work in progress under each person. Team Member Assigned To is a multiselect option with several names listed. When I use the formula below, I get a return of 0. =COUNTIFS([Assigned To]:[Assigned To], CONTAINS("NAME", @cell), STATUS:STATUS, "In…
-
Alert or update if a column value is changed based on the column(primary column)
Example - I've columns warehouse and route . I need to setup a notification or alert if the route had changed for a particular warehouse. In this example , I need to send notification or alert for Test and PR103 as the previous values of route has changed for them. can someone guide me as to how to do this?
-
Calculating days between dates, 'unless'...
Hi folks, I have a date column for 'Suggested Risk Assessment Review', and a date column for 'Planned Review Date'. I need a formula to count the days between these (i.e. how overdue are they), UNLESS the 'done' checkbox is ticked. How do I calculate this? Thanks!