-
HELP!!! - Return the Ancestor Containing a Specific Character
Hello, Level 1 Level 2 Level 3 * The Cell Contents I Need Level 4 Level 5 Level 6 I'm in a cell in the same row as Level 6 (for example); and I know that a row in the ancestors contains a "*"; how can I retrieve the value contained in the the row that contains the "*"? Thanks in advance.
-
Countifs Formula - Excluding a value in a Range
How can fix my COUNTIFS formula, where I have 5 ranges (columns), but want to exclude a value range in 2 of the columns respectively. =COUNTIFS({Range 6}, "05. Trust Administration", {Range 3}, "Bokamoso"), {Range 2}, "Must Do", NOT({Range 1}, "Existing Project", {Range 5}, "Done") What I need to count all items in Ranges…
-
Update Parent Row based on Child status
Hi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") > 0, "Open", IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(),…
-
Anyone know why this alert doesn't send?
-
IfError with Index and Match
Hi all, I am trying to troubleshoot a formula that has worked for me in the past and wondering if anyone can look it over. Typically this formula is used for a travel grid that denotes when someone is Work/Travel Out (X/T) or just Travel Out (To). Happy to share the sheet itself as well to look at further.…
-
What would be the Formula for Dates to How many Days calculation?
What is the formula to tally these columns to automatically calculate how many days the each action takes to happen? Submitted Date to First Worked on would be for Days to First Action First Worked on date to Completed Date would be for Days to Complete Submitted Date to Completed Date would be for Days Since Submitted
-
Sheet Summary Help
I think this is probably an easy thing that I am overthinking, but I cannot get the Sheet Summary Formula to work. I need to create a formula to count how many Biltmore Site Home, Biltmore Site Telehealth, Biltmore Site Office, and the same for the other site. I keep trying iterations of this formula with no success.…
-
Filling Columns based on a Selection From Dropdown
I am working on a formula and cannot get it to return correctly, I need to be able to select one of two options in a dropdown. I was using a vlookup and kept getting the N/A for all of them even if the condition was met. I think I missed an additional trigger. Regions: ABC and XYZ for the example. Based on which region…
-
Urgent Help Needed! - Percentage Won Formula with Checkboxes
We are trying to calculate our win percentage by using a formula that calculated values from two different checkbox columns. #won/#lost+#won. We have tried several formulas but have come up empty. The following formula worked but it did not calculate the correct percentage and we would rather calculate the percentage by…
-
Greater Than, Less Than, or Equal To previous month value
Hello, I'm looking for help with the following formula to show trending information. 12 Months of Data (Jan - Dec), When each month gets updated, I would like to use a formula to show symbols for trending up, down, or unchanged compared to the previous month. Does anyone know of a formula that can point me in the right…