-
Formula and Color Change in Cell
Hello, I am wondering if it was possible for the "Initial Risk Score" cell color to change when the "Probability" and "Severity" is selected? I currently have the following formula in all cells "Initial Risk Score" =IF(AND(Probability1 = "Improbable", Severity1 = "Negligible"), "1", IF(AND(Probability1 = "Improbable",…
-
Can I use 2 formulas in 1 cell/column?
Hello! I'm stuck trying to put to formulas into one column. Here's the scenario. I have multiple projects with multiple subtasks. When the Status column is updated to "Completed" I would like the Progress column to update to 100%. I've successfully completed this step with the formula: =IF(Status1 = "Completed", "100%") in…
-
How do I write a formula that adds "+" if the sum of two columns is more than 1
I have an anticipated finish date column and an actual finish date column. I have a formula to subtract the actual finish from the anticipated so that I can determine the variance. If for example the actual finish was 6 days longer than the anticipated, I want it to read "+6" and not just "6" (how it shows now). How do I…
-
Fiscal Week (in a Quarter) based on a Date Formula
Hi, I am struggling putting together a forumla that would calculate Fiscal Week (13 FW in a FQ) based on a date and taking in consideration that our FY starts February 1. Any help/advice would be appreciated! Nataša
-
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.
