-
Use Row@row to reference the row above in a column formula
I'm attempting to use Row@row along with an Auto Number column, in a column formula, so I don't have to manually update the formula when rows move within the sheet, but am not having any luck. The formula in the Est. RU Date column is RU Date, if it is populated, otherwise it should take the date in the Est. RD Date column…
-
Formula to count multiple cell values and their dates
I am looking for assistance in creating a formula that will allow me to isolate values in the Provider/Resources cell, the Type cell and count based on Visit Date. Below is the a snapshot of the sheet. As you can see, there are multiple names in the Provider/Resources column, as well as the Dept column. The first name in…
-
Can I have just one cell automatically copy over from 1 sheet to others when a new row is added
I know there is a workflow for copy row if row is added or changed. I don't want that, since it will copy all of the columns. I have 1 Master List of Names. The other sheets are specific trainings and prerequisites. I will have columns on the master list that don't need to be on the other sheets, and vice versa. I figure I…
-
Subtotal based on a filter in the Grid view
Hi, I am trying to subtotal a number column based on the data returned when a filter is applied in the Grid view? I have tried the obvious subtotal() formula but this does not seem to work, can anyone please help me with this? Thanks
-
Weird issue - COUNTIF Date Cross-sheet Reference
Hi - I'm doing a very simple cross-sheet reference for a count of dates and it's not working. Sheet 1: Date column has a series of serial dates. Column14 has a formula that is not working. Sheet 2: This has a Date Completed column. The formula in Sheet 1 in Column 14 is: =COUNTIF(Date:Date, {BPD-DateCompleted}) - ...where…
-
Children Parent % not calculating
Hello, I'm trying to build a sheet that calculates a percentage off of a Status column, but the column is not returning a percentage and the =AVG(Children) section. This is my mess of a formula =IF(IsParent@row = 0, IF(OR([Rally Status]@row = "Submitted", [Rally Status]@row = "Acknowledged", [Rally Status]@row = "Not…
-
Help stacking COUNTIFS?
I have two fully operational COUNTIFS functions that calculate independently without issue. One counts how many absences occurred in a specific time range by referencing a date column on an attendance tracking sheet. The other counts how many absences occurred in a specific location by referencing a location column on the…
-
Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
-
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…