-
Date Range and status formula
Hello, I have a metric sheet where I am trying to build a formula that references a date range column and status column of another sheet, but I keep getting "unparseable" or "incorrect argument". I have tried the following formulas: =COUNTIFS({Event Date},>=(2024, August, 1),{Event Date}, <(2025, August, 1),{Event…
-
Formula to combine data from another sheet
I just had surgery and I am trying to keep track of my medicine inventory. So I created an inventory log of my medicine and I have it split into 4 columns as I want to keep track of each medicine so that when I am running low I can ask for a refill. So I have two sheets. Medication Count Management Medication Management I…
-
index and Match that Sums everything
i have right now =INDEX({Project Tracker - By Work Package Range 1}, MATCH([SYSTEM/CABLE]@row, {Project Tracker - By Work Package Range 2}, 0)) this works great but it only comes back with the First number it finds. i need it to Come back with a Sum or Total of all the Numbers it finds. Sheet i want the info on. working…
-
Calculating % of completion based on start & End dates
I'm looking for a formula that calculates the % of completion based on start and end dates
-
Formula to determine next available date
Im trying to determine the next available date based on end date, Job status as active and the event type contains install. This formula returns a date =MAX(COLLECT({End Date}, {Job Status}, "Active")) Ive tried adding the contains install but it doesnt return a date =MAX(COLLECT({End Date}, {Job Status}, "Active", {Event…
-
Highlight parent if child task is in the past
Hi I have a sheet that has a column called Task name it has a main task with 4 subtasks (child) below it. The sheet has a Task name, Status and due date column. If the 1st sub task due date is in the past and not marked complete how do I have it highlight the parent of this task Red. If the 1st is complete it is no color…
-
How to assign points to answers selected thru drop down on form
Hello, I created a form to be used during a training exam. Each cell has a drop with 3 options, Proficient, Needs Improvement, Not covered. Is it possible to assign each option a point value ( 3 - proficient, 2 Needs Improvement, 1 not covered) and have a total calculated once completed? Thank you
-
MAXIF, MINIF, AVGIF Formula Capability
It would help to have the IFS functionality and combined statistical functionality MAXIF, MINIF, AVGIF, MAXIFS, MINIFS, AVGIFS similar to the current SUMIF and COUNTIF. IFS can shorten multiple nested IF statements and easier to formulate, read and understand when referencing multiple conditions. The combined statistical…
-
How to Calculate Age from a Specific Date & Average Results
I am trying to average the age of multiple events as of specific dates (end of each month). Currently I have "Age" calculated from "Today()" in a column in another sheet. I would like to instead calculate the Age from "Date of Notification" to "End Date", and would like to avoid using a helper column to do so. I do not…
-
Merged: IFS Formula
This discussion has been merged.
