Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
SUMIFS formula that includes a checkbox conditionIn Formulas and FunctionsHi everyone, I'd like to sum all cells in a column that are (A) in a parent row (B) have a certain name in the Producer column. I've inserted a checkbox column (called "Parent") with a formula to check the box if the row is a par…
-
Return a value, if a cell contains text from a range of optionsIn Formulas and FunctionsHi there! I'm not sure if there's an easy way to do this, so I'll try to break this out into parts: 1) I have a table with two columns - one with various text options (for easy, let's call these "flavours"), the other with the &q…
-
Match Contact column list to Email AddressIn Formulas and FunctionsHas anyone found a practical solution to match a Contact column to an email address? It can't be done in DataMesh and while I've done some searching on the board and help files, I haven't found a method to do this that doesn't require a lo…
-
IF FunctionIn Formulas and FunctionsI'm trying to create a Function where, if the status column is marked as "Completed" then the checkbox in the done column is activated. I'm not quite sure how to do that, can anyone help?
-
Formula Help... [forecasting part values for a period]In Formulas and FunctionsThe idea of this sheet is to forecast cost allocation. For example, row 3 is allocated 50% until the end of February. What I need the table to show is that 50% of costs are unallocated in Jan/Feb '22 and then from March the value jumps b…
-
Sort data conditionally from one sheet to anotherIn Formulas and FunctionsHello, I am looking to take the rows from one sheet that have "x" in column 15 and output all of them in another sheet. the closest that I've gotten is: =INDEX({Page 1 Range 1}, MATCH("X", {Page 2 Range 2}, 0), 1) Whic…
-
-
-
Countifs for multiple columns with exclusionsIn Formulas and FunctionsI currently have 3 columns I am using for a chart. I have no problems with the reports because they are based on filters. Current Filters Region = All Regions Business = Business is not one of Location = Location is not one of How do i co…
-
Divide By Zero Error(again)In Formulas and FunctionsHello, I am getting a #DIVIDEBY ZERO error when using the following formula: =ROUND(AVG({CDuration}, {CDuration})) What's confusing is that I am using the exact formula in another sheet and the formula is working as expected. I have went …
