Formulas
Discussion List
- I have a dropdown list in a column named "Status" where we track the progress in a process. The dropdown list contains the following choices: Initial Testing Ready for Review Ready for Retesting Ready…
- Hello everyone, I'm having difficulty writing a formula and would like to ask for your help. If in the fourth column of the image below, a risk condition has been identified, I would like to sum the v…
- =IFERROR(INDEX(COLLECT({Master Unit/Manager List WI Range 1}, {Master Unit/Manager List WI Range 2}, [Site]@row, {Master Unit/Manager List WI Range 3}, [Department Name]@row),[{Unit/Manager List WI Ra…
- I am creating a sheet summary. I would like it to count only those in January and my column range cells are not blank. I feel like I am so close. =COUNTIFS([Audit Month 2]:[Audit Month 2], "January", …
- Current Build: When Creating a row report, you can filter by Column data. Example: "Month = 3" or "Percent > 75%" Concept: I want to be able to apply basic Formulas to custom filter data. Example: Mon…
- Hi smarties, I have 40 metric sheets (one per location). In each sheet I have an countif formula that references a data sheet. I have this formula in about 20 columns. A sample is in the screen shot. …
- I have a column that auto-populates the number of days left between now and a project launch date. =NETDAYS(TODAY(), [Effective Date]@row) is the formula that I have in the column, and it works when a…
- Hello, I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message. My current formula in the "Change" column is simple: =([Availability %]@row - [Previous Availability %]@row)…
- Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I ke…
- Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In…