-
Nested(?) If statements
Not sure if nested is the right term. I want the formula to show - If any of these columns (IT, SUS, HSE etc) have "Not Achieved" in them then look for the largest/ latest date from the columns IT comp. SUS Comp. HSE Comp. and display that date. Otherwise "Badges complete". The result column is a date column so not sure if…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
Logic for Required Fields on Forms
I have a form that I am working on where I would like this logic: If box is checked, then field is required I spoke with support and they informed me that this is not a currently available feature. What I'm trying to do on my form is have it so if the user checks a box that they want someone to reach out to them, then they…
-
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…
