-
How to count the number of times a value appears based on multiple criteria in another column?
Hello, I am trying to create a formula that counts the number of times an email appears based on a number of selections made from a drop-down menu. The process is for counting the number of trainings completed per quarter per employee. The trainings are submitted through a form and only one training title can be submitted…
-
Problems with Sumif formula
Hi, I'm trying to work out what's wrong with this formula. Any help appreciated. Thanks =SUMIF({Plan Metrics Range 2},(HAS(@CELL),[Work Stream Members]@row),{Plan Metrics Range 1}) Plan Metrics Range 2 is a column in a calculations sheet which has a list of team members across multiple teams (contact list) Work Stream…
-
IF & Vlookup
Hi there, I am trying to complete a VLOOKUP with an IF Statement but its returning a blank despite data being available in the cross-reference sheet =IF([Ex Works]@row = "Yes"; VLOOKUP([Product Number & Name]@row; {Item Master Range 1}; 3; VLOOKUP([Product Number & Name]@row; {Item Master Range 1}; 2))) What am I doing…
-
Remove all values from a multi-select column if they appear in a different column
I have two columns, one with a list of potential instruments and one with the instruments that aren't available. If I created a third column for instruments available, how would I remove the used instruments using a formula? All are multi-select columns
-
Pulling next date from a sheet
Hello! I am looking for assistance with a formula that can pull in the next action date from one sheet to another. For context, we use sheets for customer renewal project plans. We also have a tracker that gives an overview of all the project plans and their name, completion, next action date, status, etc. What I would…
-
How to change color in Status Column when checkbox is checked.
I am looking to set my Status Column to Blue if the Done Column (checkbox column) is checked. I think I am having an issue with referencing the checkbox column properly. Would love any help. Thank you.
-
Auto copy from one column to another, but only IF...
I'm looking for a formula to copy information from one drop-down column to another automatically, but only if a third column contains a certain word. Is this possible? For example: Column 1 could say say "Title" or "something else" Columns 2 and 3 have a drop down menu of "In progress" and "complete" If Column 1 says…
-
The dreaded #invalid data type
Hi guys, I'm progressing with my basic formula however what do i need to add into the below formula as an example so i don't get the unsightly #invalid data type in a cell just because the start date is blank? =IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row)…
-
Formula to populate parent from one column in another?
Hello, I'm am combining a bunch of sheets in one and then reporting off of that. For reference, the application is resource tracking, so lots of project plans that I'm combining in one so I can report at a "portfolio level". Is there a formula that will do this? I want the parent text from the Task Name column to populate…
-
Using Index Match for Multiple Value Dropdowns
Hello, I'm trying to utilize index matching for some metadata sheets and using the formula I am currently utilizing, the data appears blank. The formula currently being used is: =IFERROR(INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Impact/Benefits]$1, {Portfolio Summary Header Row},…
