-
Help with multiple condition 'IF' and sum of results from 'THEN' statement
I am looking to get help to create an 'IF' 'THEN' statement that states: If: Text=Defect, Month=Sep, Year=2020) THEN: Sum the dollar amount from a column X which is relative and in the same row as Text 'Defect' Else: Leave blank I've tried IF, THEN statements and INDEX and IF(AND and all give me errors. Any help is much…
-
Using a Logical formula to return a numeric value
I'm trying to use a logical formula to return a numeric value based on the drop down selection in another column. For example, if column X contains Tier 1, insert in column Y a value of 1 If Tier 2, return a value of 2 If Tier 3, Return a value of 3 This is the formula I'm trying to use and I get an unparseable error…
-
What formula would I use to find the Task Name(Column 1) with the soonest due date?
I set up a checkbox Helper column to be checked if the Status column of the task is "not started" or "in progress". I would like the sheet summary to reference the Task Name with the soonest date in the Due Date column if the Helper column is checked. Is there a formula that would accomplish this?
-
Formulas to identify current project phase, next task due on a project plan and the task due date.
Hi everyone, To help us report the current position of a number of projects, we have been asked to report on the current phase and next due task. So I need to find formula's that can identify the following 3 things:- What is the current phase of a project. On example below, "Defined, Scoped and Analysed" is the current…
-
Having trouble with IF "CONTAINS" function
Hello, I have a column with a dropdown list that allows users to select Yes or No to satisfy the requirements of a question. If the user choses “Yes” they are then required to provide details to explain their answer. To eliminate blank cells on the sheet where the answers are recorded, I used the following formula to…
-
Count If from Roll Up
Hi all, I am trying to count the number of occurrences of certain keywords from a sheet column into a rollup. I cannot seem to get the formulas right. Error coming up as #UNPARSEABLE Keyword "HHS", Sheet Name "25", Column Name "Funding Agency" =COUNTIF({25 Range 1}[Funding Agency]:[Funding Agency], "HHS") A little…
-
Countifs Question
HI I am trying to do a Countifs using the below, the result keeps coming back as 0 but I think that is because the box only has either Pass or Fail in it but not both in the same cell, I am trying to add up all Pass and Fail Inspections, how do I include both Pass and Fail results. =COUNTIFS([Building Unit]:[Building…
-
Find the most recent date
Hello everyone, Is it possible to find the most recent date, from an available date range ? Thank you very much
-
set time
Hi, =IF(Processtype@row = "Fast", Starttime@row + 30, IF(Processtype@row = "Long", Starttime@row + 60, IF(Processtype@row = "Large", Starttime@row + 120, "Not Proper process Type"))) Actually i would like to do, if procees type Fast ,, add 30 min more with starttime, Long means 1 hr,Large means 2 hr,, can anyone pls help…
-
How do I cusomize system generated date created?
This generates a date and a time. How do I customize so I just get the date. I can then use a formula to count across a date range. I cant if thee is a time in the cell too.