-
Nested If Formula
Hello, I am trying to create a nested IF formula based on the criteria below. Below is also a screenshot of what I am trying to do: =IF([% Complete]1=0,"Not started" =IF([% Complete]1>=0 and <=1, "On track" <code class="CodeInline">=IF([%Complete)]1=1,"Completed" =IF([%Complete)]1<=1 and Due Date is past,…
-
Formula to return parent row for current week
Hi community, I'm attempting to find a formula that will return the parent row where the end date is equal to the current week. I have created a helper column that calculates the current week number. Now the question is what to do with it to get the result I want. Any ideas on formulas to use? I'm leaning toward…
-
CountIFS & Counting Dates
Hi All, I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and the Date Installed has a date then I need to return the value for the total number of existing devices installed. Any help…
-
Sheet Summary issue - How to exclude Parent rows from the Counts
I would like to set up Sheet Summary to show a counts of Open Tasks, and Completed Tasks - based on the column "Done" being checked or not. The "Parent rows" are for reference only, they are not Tasks and shouldn't be counted in the Summary Sheet. How can we exclude them from the Summary Sheet counts?
-
At Risk Flags
How do I format my At Risk column so the flags only appear in the "children" rows, as shown in the screenshot?
-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
-
Multi-Select
I have a column that has approx 20 multi-select options. I am wanting to run a report that shows a count of any instance in the sheet where let's say HSW has been selected. Column is annotated as a multi-select column/field. Column name Allegation I have tried to run a formula fr count if - but it only picks up the number…
-
Count # of rows of text in a cell
Is there a way to count the number of rows of text within a cell? I know this will change dependent on column width but if I keep my column width static, I need to know how many rows of text I have within a cell.
-
Assign a value based on a date range
Hi everyone, Fairly newish user when it comes to formulas here; please forgive me if this has been answered elsewhere and I missed it in my searching. I'm wanting to assign a value to a column named Bucket based on the value in the Start column for any given task. The date ranges look like this (using a numbered list for…
-
Formulas =SUMIF
Hi, I need help to solve this puzzle. I'm using this sumif formula =SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value}) to sum up the total value of invoices against a particular order number. I've checked that all columns are formatted as text. See snap shot of actual…