I would like that the check box in a column is checked when the task is a child and also when the % complete column is 100%. My formula: =IF(AND([% Complete]@row = 100, Level@row = 0), 1, 0) This does…
Can anyone help me with a formula for a multi-select column where I am counting the number of occurrences of two of the options? I think it would be a COUNTIFS(CONTAINS(OR( formula, but can't seem to …
I have a text column that has multiple emails and each email is separated by commas and i am trying to pull those multiple emails to contact list columns (I have allowed multiple contacts per cell ON)…
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…
