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 condition
    In Formulas and Functions
    Hi 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…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Kristina Todoric
  • Return a value, if a cell contains text from a range of options
    In Formulas and Functions
    Hi 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…
    Answered - Pending Review
    22 5
    Answered - Pending Review 22 views 5 comments Most recent by Jeff Reisman
  • Match Contact column list to Email Address
    In Formulas and Functions
    Has 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…
    Unanswered
    19 0
    Question 19 views 0 comments Started by ker9
  • IF Function
    In Formulas and Functions
    I'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?
    Accepted
    14 1
    Accepted Answer 14 views 1 comment Most recent by ChloeSmith
  • Formula Help... [forecasting part values for a period]
    In Formulas and Functions
    The 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…
    Unresolved
    19 1
    Question 19 views 1 comment Most recent by Ryan Rooke
  • Sort data conditionally from one sheet to another
    In Formulas and Functions
    Hello, 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…
    Accepted
    17 2
    Accepted Answer 17 views 2 comments Most recent by lmiller
  • recievers do not recieve email sent from smartsheet
    In Formulas and Functions
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by ChloeSmith
  • #UNPARSEABLE ERROR - Please assist with the formula
    In Formulas and Functions
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by ChloeSmith
  • Countifs for multiple columns with exclusions
    In Formulas and Functions
    I 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…
    Accepted
    18 4
    Accepted Answer 18 views 4 comments Most recent by Jacque Hale
  • Divide By Zero Error(again)
    In Formulas and Functions
    Hello, 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 …
    Accepted
    24 2
    Accepted Answer 24 views 2 comments Most recent by LeAndre P