-
Average Formulas
Hi all, Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin location. Below if formula I am trying, but I'm not getting any output. =AVG(COLLECT([Transit Days]:[Transit Days],…
-
Auto-Fill Rows of Data Based on Criteria
Is there a way to have the Sheet Summary auto-fill multiple values based on a selection from a drop-down field? I would like to have "country" be the drop-down select field and based on the country selected, the fields below would populate based on the values from another sheet. Example, If Austria is selected then the…
-
Link to Parent on the same sheet
I've got this formula that returns the Name of the Parent =PARENT([Name of Request]@row) But, I'd like to add a link to the parent rather than simply return the Name of the parent My use case is Tasks (Parents) and SubTasks (children) In card view, on the Child, I need to add a link to the Parent as the children will be…
-
COUNTIFS with other IF criteria and referencing other sheets
Hello! Context: I'm leading the charge on tenant migration for a datacenter over 7 weeks. There are 10 teams (each with their own inventory sheet) and hundreds of services among all the sheets. Goal: track completion metrics across all teams, one week at a time. This would include total number of services and number of…
-
Count If a specific department answered "Yes" at least once
Good Morning! I've created a conflicts of interest survey and I'm looking for a formula to then reflect on my dashboard for reporting. Can someone please help me identify how i can use a formula to count if someone from a particular department answered "Yes" at least once within 5 questions? My point is to count how many…
-
IF Multiple values selected THEN VLOOKUP and return values
Is there a way to return values in a cell if multiple criteria is met? I would like to track the amount of time our Onboarding Coordinators spend on tasks for each Country. So when they create a contract in Austria it takes 60 minutes but for Croatia it takes 50 minutes. For a contract to take 60 minutes, date fields…
-
Request Time Off Tracker Help
Hello, My story seems to be familiar to others, but no past post seems to have a good solution. I've been searching the community forums here for a request time off tracker template (found a couple none actually worked), ended up creating my own. I got the majority of the automation and formulas worked out but I'm stuck on…
-
How to pre-populate empty cells.
Because I haven't found a better place to say this, and because a great deal of this has involved Formulas etc., I wanted to express my gratitude to this community. I'm not usually a community guy mostly because I feel intimidated. But what I'm trying to put together for my company has been important enough I was…
-
SUMIFS with sheet references.
Hello, I've got this formula working like this. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation") However when I change the criteria to "PPL / Sick" it's returning 0 when there are clearly cells to count. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "PPL /…
-
Last 7 Days Formula
I am trying to calculate how many IT tickets have been moved to the status of "completed" within the last 7 days. The formula returns a value of 6 but when I use the filters on the report, it returns the correct value of 2. Can someone help me with the formula so it returns the correct value of 2? The formula I have is:…