-
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?
-
Check button on form to check calculations prior to submitting the form
I am creating a end of day banking form to include all cash and eftpos transactions recorded currently in Excel. It would be great to have a Check button that checks all the calculations against a formula column to ensure it balances prior to submitting the form. If it is incorrect then it would produce an error and not…
-
Need Help with Collect or Index or Lookup. Help please!
I have a grid that is pulling YTD actual expense from another source. I have added a helper column to the right of YTD budget. I have a sheet with the exact same layout that includes year-to-date budget expense. I am trying to select the correct month from the helper cell (ie - "Apr-26") and have the YTD budget pulled from…