-
Compare 2 Multi Select Drop Down Columns
I have 3 columns, all have the same multi select drop down options. I want the first column to be my selection, the second column is more of a checklist of what's complete, and the third column tells me what is left to be completed from the first column. Any idea if this can be done? Tried using collect formula.
-
How do I average children?
Please help! I am trying to come up with a formula to put in the parent row to get the average % completionof the children row. My children row % percentage completion are filled in using this formula: =(IF(Pulled@row, 0.5, 0) + (IF([Source Termed (FROM)]@row, 0.2, 0) + (IF([Device Termed (TO)]@row, 0.2, 0) + (IF([Source…
-
Calculate Answers from Form input
Hi I have a forms with 16 questions, the questions have one of four answers A Rarely seen B Occasionally seen C Frequently seen D Seen majority of the time I want to calculate the total across the rows with a vaule for each of A = 1 B = 2 C = 3 D = 4 Is there a formula that can do this? =IF(([Q1]1 = "A Rarely seen"), "1",…
-
How do I align user's role based on a point in time occurrence?
I manage a vendor relationship that includes tracking the usage of their services on a monthly basis. The vendor services are available to multiple internal groups and part of the reporting is tracking the percentage of total services that each group utilized in a given month. On occasion, a user may transfer to a new…
-
COUNTIF Formula for Contact Column
I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that counts the number of times their email address is in the Contact column. However, the…
-
Formula
Hello, I have two sheets set up. I want to transfer data from one sheet to the other. I have a column (Column 1) on both of these sheets which contains values that with spelled exactly the same. I want the data pulled from (Sheet 2 Column 6) this column is a checkbox and in the other sheet (Sheet 1 Column 2) it's a drop…
-
Help with Formula
I'm trying to help someone on my team. Below is a modified snap of the spreadsheet.. The desired outcome is to return the next date in line that is NOT CHECKED. For example, the "Current due date" for the first row would be 9/24/21...the second row would show 9/17/21. I've been working through the "If" statements but am…
-
Extracting a date from a text field
Ok, now... I have this data in one text column "2021-09-14 12:02:51" and I'm tryng to extract the date only (i.e. 2021-09-14) from this data and have it stored in a DATE column in the same sheet. I've tried many different ways but just can't make it work... I'm getting frustrated ;)
-
Can a Contact column populate based on selection in another cell?
I have two columns; Workstream and Workstream Leader. Their column types are Dropdown (Single Select), and Contact List respectively and each contains five available selections and are set to Restrict to list values only. I want the Workstream Leader column to populate with the contact that I know to be responsible for…
-
Countifs on a column that is a multi-select drop down..
I am trying to do a countif and one of the fields is a multi-select drop down and isn't returning the correct value, no idea what to do R4+ BP007 Change Inventory Range 1 is the field that is the multi-select column. =COUNTIFS({Status}, =[01 Open]$1, {Primary Function}, =$[Primary Column]5, {Fit/Gap}, ="Gap (Core…