-
Parent Formula to display modified child status
I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change. For example: If I change the status of "Software" to Red (R) in the child row, it should change the Parent status to Red. The parent row captures any child row that changes from…
-
How to get all rows with 1st column starting with specific alphabets
Dataset: Required Output: I am trying to extract data from the rows which have its first column starting with particular contents. As I have shown in the attached example, I wish to get data of columns A, C, and D if the column A starts with 'as'. Please help me to achieve this. Thanks!
-
Helper Column Formula
Hi, I want to use a helper column to uncheck a Checkbox column if a certain condition is met. i.e. If [Order Date] contains a date then [Order Required] is unchecked. I can't put the formula into the [Order Required] column as it already has a =IF(OR(ISTEXT([Quantity Required]@row), ISTEXT(Unit@row)), 1, 0) formula in it.…
-
Using values returned by formulas in other formulas
Hi, I have a user populated field (using a dropdown) where the options range from “1-Innocence” to “5-Excellence” – this makes more sense to a user than simply having a 1-5 available for selection. To summarise these ratings per theme, focus area, assessment, etc. I obviously need to make use of the 1,2,3,4,5 values in the…
-
Formulas in sheets with auto-number columns
I have a sheet with an automatic numbering column. Data for this sheet will be captured through a webform. I need certain columns, which will not be populated throught the webform, to have formulas in them. How do I add those formulas without adding them in the first row which triggers the automatic numbering? I thought of…
-
COUNTIF(S) where items are NOT equal to more than one value
Hello! I am trying to create a formula which counts all items that are NOT assigned to a list of about 8 people. These will be totaled into an "Other" field. Example: PMs include Bob, Sarah, Dee, David, and George. I have counts for how many projects are assigned to each of these people, no problem. Then I have a bunch of…
-
Validations/checks before changing the status of a row
Hello, First of all thanks in advance for support. I have a question, which i think is basic.... but i haven't find the way to solve it. I have a sheet with a status column, then i have 2 columns for KPI values: Status, KPI1, KPI2, start date, end date, etc.... I want to "not allow" to complete the task if the columns with…
-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the status column and the Due Date has been exceeded by 3 days. I've had nothing but headaches in trying to figure this out. I would be very grateful for any assistance you can provide with the IF formula…
-
Average Turnaround Time
1) I have a column for turnaround time, which calculates end date minus begin date, considering holidays and workdays. I then do a summary formula which averages the total turnaround time. 2) I have another column duration, which calculates today's date minus the begin date. 3) I have another column that is a status of…
-
IFERROR Not Returning the Correct Message
Hello! I am using an IFERROR with Index/Match and it will not return the error message of "Pending" as I am requesting in the formula, it just shows blank. I'm not sure why: =IFERROR(INDEX({Data Dump || Pre-Hurricane - iFormBuilder Range 2}, MATCH([Building Name]@row, {Data Dump || Pre-Hurricane - iFormBuilder Range 1},…