-
Changing Drop Down Value Based On Current Date?
I am trying to change the drop down value on my Health column based on the current date. Is this possible? ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.
-
Count only if Parent
I have a [RowID] column that is populated by this formula =IF(ANCESTORS@row = 0, COUNT($ANCESTORS$1:$ANCESTORS@row, "")) It returns sequential numbers but, I need it to only count if Ancestor = 0 Secondly, I need the result fill format to look like this 0000 (like an auto number) 0001 0002... 0100 0101 0102.. 1000
-
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.