-
How do I keep parent child row structure when moving items to and from other sheets?
I am working on setting up recurring tasks for my teams timeline sheets. I have 2 sheets set up to help the recurring task functionality. My question though is around if it is possible to set something up so that when an item is marked as complete the parent and all child rows are moved and they maintain that structure?…
-
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
-
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.