-
Formula Help - Open, Pending, At-Risk and Complete
Hello, I am looking to create a formula if a request is/was submitted I would like it to display open, pending, at-risk, or complete. I also need to exclude changes to that request if the status reflects canceled, rescheduled, no-show, or declined. Currently, I have a vlookup to display only the open or completed requests.…
-
Populate date based on two other date columns
I have a Planned Finish and a GTG Date in my sheet. I created a new date column "Replanned Finish" and I would like the date to auto-populate with the Planned Finish unless there is a GTG Date. If there is a GTG Date I would like that date to populate. Any ideas how to build a formula to do this? I looked and I can't use a…
-
Question about SUMIFS with CHILDREN with multiple criteria
The sheet summary formula "TEST" which is looking for the number of recorded docs Alex did for Friday. What I have right now is =SUMIFS(CHILDREN(Recorded:Recorded), CHILDREN(Name:Name), "Alex", CHILDREN(Day:Day), TODAY(-3)). It works if I remove either the day criteria or the name criteria but returns zero as it is above.…
-
How do I total the answers from a drop-down cell?
I'm trying to build a dashboard that will show the progress of sites completed for an upcoming upgrade. I have attempted several ways to compile this information automatically and I'm at a loss. I think a simple cell formula might be the easiest way to accomplish what I need then I can link the cell to a report I create.…
-
Lock row function
I want to lock 'Start date row' in the Summary section when Initiation and Planning is 100%. Can someone please help on the Automation. Thanks in advance.
-
If formula
I am trying to use below formula but it is showing error as Invalid Operation. How to use 'less than equal to' function in 'IF' formula: =IF([a%]@row > "5%", "Red", IF(AND([a%]@row < = "5%", [c%]@row >= "5%"), "Yellow", "Green")
-
Refresh Sheet Without Opening It?
Hi All. Can anyone suggest how to refresh a sheet without manually opening it? Reports on my dashboards are displaying errors related to linked cells not refreshing. For the last year, until last week, I had a workflow in place that "locked a row" at midnight and then unlocked a row at 1am. The workaround no longer works…
-
Averaging Wait Time if an Inbound Call
Hello, I have read through many of the other discussions and have not been able to find a solution to my issue. I am trying to average the wait time of inbound calls, based on a column called Offer Duration, and confirming that the column Queue Name has the word Inbound within the field. Below is the formula I am trying,…
-
Filter and Calculation
Can we keep specific rows visible when applying filters? Can parent rows visible when using filter? Can we apply multiple filters? I've seen the articles discussing about it but not sure if it works now. I'd like to keep the rows for calculation (Functional Summary to Column15) visible and calculate the numbers when I use…
-
Make calculations from 3 different sheets
Hey, I have 3 sheets: Holidays, Quarterly planning and Teams Vacations. I want to sum the VACATION DAYS (in holidays sheet- picture no.3) to col Holidays (in Team Vacations sheet- picture no.1), BUT only those who are on the same Q and same Team name and also match with the dates that in Quarterly planning sheet (picture…