-
Formula for Priority Cell
Hello All: I am having a difficult time creating a formula that will give me Priority. Below are my rules for Priority Status. Thanks Urgency High If Impact High and Urgency High, then Priority is 1 If Impact Med and Urgency High, then Priority 2 If Impact Low and Urgency High, then Priority 3 Urgency Med If Impact High…
-
Countifs in date range and value range.
I am stuck on this formula, it doesn't become unparseable but it doesn't result in an accurate count. My goal with this is to is to keep an annual tally of a specific age range of patient the formula is as follows: =COUNTIFS({Trauma Chart Audit Age}, <15) + COUNTIFS({Trauma Chart Audit Age}, NOT(ISNUMBER(@cell)), {Trauma…
-
Workflow Not Working
I have a workflow to copy rows to another sheet if a checkbox is checked (the checkbox column has a formula in it to make it checked depending on another cell). Please see the attached images for what the setup looks like. The rows are all pre-populated due to formulas required in each to calculate out information. That's…
-
Is there a way to move /copy or link attachements only from one sheet to another sheet?
Is there a way to move, copy, or link attachments only from one sheet to another sheet based on matching criteria?
-
Update a Symbol column based on another sheet's checkbox, whilst maintaining other information
Okay, I have a three-part problem that I, in no way, can solve on my own. Question 1 Above is a destination sheet we use that determines which operators are cleared on specific disciplines. We'd like to automate this based on the Cleared column in our main training source sheet (see picture below). When that checkbox is…
-
Multiple IF Statements
I'm hoping someone can help me determine the error in my IF statement. We have tasks in our projects assigned to a specific role: either an SL (Senior Lead), SPL (Senior Project Lead), or a PC (Project Coordinator). I have those initials and the person assigned to those roles at the top of my sheet. I.e.: PL Steve Smith,…
-
Counting multiple columns, per person for not blank
I know this should be easier than I am making it but.. I need to count per person, the number of columns with dates OR the number for not blank divided by 2. Help please :)
-
Conditional formula IF number show "text"
I need to create a formula in a new column that automatically shows " probability" depends on the % entered manually in column "Probability to win". For example if i input 5% should should "Very low" Depends on % that is entered on column “Probability to win” return on “probability” column: If Blank – TBD If 0%-5% = Very…
-
Is there a way to calculate percent complete in the summary page without parent/child relation?
I have a action tracker for my department. All information in as via a form. I want to use the Summary Sheet to show overall % complete of all tasks based on the % Complete column. Is there a way to do this in the summary sheet without having to create the parent child relation?
-
Adding months to a cell linked date
Hi everyone, I am trying to add 3 months and 6 months on from a date that comes from another sheet. =DATE(YEAR([Date (Hidden)]5), MONTH([Date (Hidden)]5) + 6, DAY([Date (Hidden)]5)) That is the formula I am using. As long as it is in the same year this formula works but if the it goes into the next year the formula becomes…