-
Need to add column data from one sheet IF customer name and ticket # matches both sheets
I tried using =INDEX(COLLECT({Completed Alterations}, [CUSTOMER NAME]@row, {CUSTOMER NAME LOOKUP}, [Ticket #]@row, {TICKET #}), 1) and this is not working. I cannot figure out why. Completed Alterations is the data from sheet 1 that i want added to sheet 2 IF the customer name & ticket number (from sheet 1) match what is…
-
Multiselect Dropdown Parsing
Hello all, I have 3 columns in a sheet. 1 is a multi-select dropdown ("MSD"), 1 is a single contact ("SC"), and 1 is a multi-select contact ("MSC"). In the SC, I want to take the first dropdown value from the MSD and use it to index match a value from another sheet. In the MSC, then I want to take the remaining values from…
-
Formula to collect resource's start date
Hello, I am trying to create a formula that will collect the min. date for the resource listed at row for various projects. If the resource isn't listed as a task owner, Right now, I am getting a blank response instead of my initial start date for a project. Current Formula: =IFERROR(IF(CONTAINS(Resource@row, {Task…
-
How do I split Three columns?
How do I split the value of a drop down menu into a total of three columns? The column with the drop down menu I would like the first name only to remain, the second to only contain their email and the third their phone number?
-
Level Formula Not Working
Hi! I have been using the same level formula for a while, but for some reason on a newly created sheet, my formula isn't working, and I can't figure out why. Here is a screenshot of the relevant columns: The formula I've entered is: =(IF(COUNT(CHILDREN([Study Protocol]@row)) > 0, COUNT(ANCESTORS([Study Protocol]@row)) +…
-
Help Needed.
Why does this function not work ? I'm trying to do a countif function that recongizes the status of an event but only looks at the events with valid due dates =COUNTIFS(AND([Column4]@row = "In-progress", [Column6]@row = ISDATE(1)))
-
Assigning value to the newly created duplicate rows without changing the first entry
I am working on a formula for the column that should tell me whether Vendor Name in my Vendor column is entered for the first time ("New Vendor") or whether it has been already used ("Renewal"). Logic for those values New Vendor/Renewal values is: New vendor (Meaning first ever request raised for the vendor) if: No other…
-
Dependent drop down list
This any way to have the dropdown lists only display certain options based on what is selected in another cell e.g. If you select January in the Month cell the drop down box only displays the week commencing dates in January?
-
SUMIFS
Hi all, Trying desperately to get this to work. I want a sum of all the cells in a column if a date is between x and y. So I really want to create 12 fields that show the sum of all OB Calls in January, February, March, etc. Can anyone help with the syntax for this? None of the "date between" type formulas I enter work.
-
Formula to calculate the percentage of occurrences in a range of cells w/ 2 criteria
Good afternoon! I am trying to calculate the percentage of occurrences within a range of cells in a row that contain either the yellow or green bubble symbols. I can get it to work properly for 1 criteria (or color of bubble) but not for either of 2 colors. How do I get the below formula to divide the number of green OR…