-
Max out Cross sheet reference ?
I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the cross reference but didn't work.
-
Conditional Formatting on Task/Outline Level Formula
I want to format rows based on the Outline Level. e.g. 1 = a darker color, 2=lighter, 3=lighter than 2, etc. I am using a formula to calculate Outline level: =VALUE(COUNT(ANCESTORS([Task Name]@row )) + 1) However conditional formatting is not working. What could allow this to work? Thanks so much!
-
Formula limits?
I have a sheet and I want the checkbox option to appear as checked if the cell in the name column of the same row is one of 133 options- is this possible in a single formula?
-
Combining data from 3 different columns to create a summary report
Hi all. I am trying to create a summary repot that combines 3 columns that I have on an Intake Sheet and Archive sheet. The data that is in each of these columns are pretty much the same, but we have them separated out based upon on the different clients that we have. Within these 3 columns, it has Job type data (i.e.…
-
Calculate days remaining until task due date
I'm trying to calculate how many days remain until a task's Due Date, but only if the Status is not "Complete." If it's complete, I want the cell to stay blank. What formula should I use?
-
AVERAGEIF with OR function
Hi — I'm trying to write a formula that captures the average of the CD column only IF it's in the CD, permitting, or construction phase. Below it only has 2 of the phases; i'm not sure how to incorporate the third. My current formula is giving the #INVALID DATA TYPE error: =AVERAGEIF(OR({Metric.Phase}, "5.Permitting",…
-
Formatting Values with Join Collect
Hello! I had used a join/collect formula to pull the data from another reference sheet. I need help formatting the money and the percentages. Here are the formulas I used: =IFERROR(IF(AND($[Primary Column]@row = "Include", COUNTIF({ACT_Vendor Name}, $Vendor@row ) > 1), "$" + JOIN(COLLECT({ACT_Total Contract}, {ACT_Vendor…
-
How to count one name in a multiple contacts per cell column
I am trying to use the count function to counts names in a multi-contacts column and it is not working. Help! I need to count how many times each of my testers are assigned to an UAT.
-
I use the sum(children()) formula and it is not adding all rows especially the last row that was added- what are the reasons why and how to fix it?
Here is an example where the sum children formula isnt adding correctly and sums to zero when it should not
-
AI In Tables
I'm trying to look into using the AI tools for generating formulas on my enterprise acct. Is there a reason why it wouldn't be showing in my resources on the right side of the table?