Formulas
Discussion List
- 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 ha…
- 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 t…
- 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 n…
- I'm looking for a formula that calculates the % of completion based on start and end dates
- 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")…
- 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 …
- 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 - pro…
- 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…
- 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 calcu…
- This discussion has been merged.