-
Department Helper Column Rollup Multi Select
The goal here is to create a helper column that with a formula will grab the department information from each task row, and then roll that up into the parent phase and project rows. However sometimes there is a department in the parent rows that are not in the task rows. So I need to be able to grab information from not…
-
Parent Row Schedule Health functionality
Hello, I have a column formula that is returning random results, mostly on parent rows. The formula is: =IF(Status@row = "Complete", "Green", IF(OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "On Hold"), IF(ISBLANK([Target End Date]@row), "Red", IF([Target End Date]@row < TODAY(), "Red", IF([Target…
-
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
-
My 'And' formula is not working
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 doesn't update the checkbox even when both conditions are true. I tried saving and refreshing. Strangely, this formula in…
-
COUNTIF CONTAINS(OR(
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 get it to work. Thanks!
-
How to convert multiple email separated by commas from Text column to Contact list column?
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) and be able to send alerts. However, when I do that it just stays as text, not contacts. Does anybody have any idea how I…
-
Count Every Time Two Specific Dropdown Items are Chosen
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 for 2nd Review App Support Request Submitted Completed ON HOLD No Longer Needed I'd like to count the number of times that…
-
The sum of values in the next row
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 values below the row where the risk was identified, without including the row classified as a risk in a new column right…
-
What am I doing wrong in this formula?
=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 Range 4})) My goal with this formula is: if SITE and DEPARTMENT Name on Sheet1 matches SITE NAME and DEPARTMENT NAME on sheet…
-
Count is not blank
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", NOT(ISBLANK([Test Issue 1]:[Test Issue 4])))
