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…
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: Th…
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(Is…
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…
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"…
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 …
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 Starte…
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 Sele…
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 …