-
Text to different Rows - Split by delimiter.
Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?
-
IFERROR and OR
I have these two formulas in different columns: =IFERROR(INDEX({Frame ECN Updates Range 2}, MATCH([ECN / PLR / FF / CEG]@row, {Frame ECN Updates Range 1}, 0)), "") =(IFERROR(INDEX({Frame Feedback Updates Range 1}, MATCH([ECN / PLR / FF / CEG]@row, {Frame Feedback Updates Range 3}, 0)), "")) Individually, they each output…
-
Index Match Help
Hi! any help on why this formula is not working? =INDEX({Operations BOB LON H}, MATCH({Operations BOB Range 4}@row, {Operations BOB Project Code}, 0)) this is a similar formula that we have and it is working: =INDEX({Ref. BOB Range 1}, MATCH([Project Code]@row, {Ref Project Code}, 0)) they appear the same to me, what am I…
-
I need some help with custom rounding in decimals
Hi all, I am trying to find a way to use custom rounding within a formula. I've tried using the AI formula generator, but it ignores that part of my request. I have also searched for help online but no luck. Essentially I want to create the following custom rounding based on the outcome of a formula - Between 0.01 and 0.24…
-
Absolute Reference changes if cell is moved
Hi, Looking for help with Absolute references in cell formulas. I need the formula reference to remain the same even if the user moves or copies the cells to a different column. The scenario is Column8 has the formula =SUM([Column 6]@row, [Column 7]@row) If a user moves the Column6 cell to Column9 , the reference in the…
-
JOIN is missing items when joining multi-select dropdown column
I have a dropdown column (multi-select) that lists participating districts. Each row is a different program that can have different districts or sometimes the districts repeat. I am trying to count how many unique districts participated. In a separate column (dropdown - multi-select), I am trying to use JOIN to pull all…
-
Join Collect Formula not pulling contact info
I have a formula pulling contacts from one sheet to another that is working HOWEVER, it's not pulling them over as a contact with their emails attached and I have automations set up for email reminders and they won't be delivered because its not an email and just a name. Both columns are contact columns btw and everyone's…
-
Combining IF(AND and IF(OR statements
Hi all, I am trying to build a combined IF statement for a date validation field. Both of these statements work on their own. The first statement returns "University Holiday" if the "Preferred Date" is a holiday... =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19",…
-
Formula Consolidation
This was originally a checkbox column to see if an estimated was within a 10% margin on either side, but now I need it to account for if it is under/over the 10%. Currently, three checkbox columns exist, with the following formulas: EST GOOD - =IF(AND([HR PER UNIT / EST]@row > [10% DOWN]@row, [HR PER UNIT / EST]@row < [10%…
-
Count how many per Month and Year for Summary Sheet?
Hey - I'm trying to create a summary sheet for photo data. I want to count how many Photo shoots are happening per month/year. The screenshot is below is our "Comp" sheet that has the data I want to pull for the summary sheet. So ideally, I can then create a graph for a dashboard. The AI generated this formula:…