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

  • INVALID VALUE
    In Formulas and Functions
    The column with the invalid value is a column formula. Although there are some rows where arrival and end are blank, there are a few that will give a invalid value. This is the formula =IF(AND([email protected] <= [REF DATE]@row, [END DATE]…
    Accepted
    15 2
    Accepted Answer 15 views 2 comments Most recent by Mary Kam
  • Display Number only if 2 conditions are met
    In Formulas and Functions
    Good morning, I am trying to display the lowest bid in a column only if the [BID AMOUNT] cell is not blank AND if the checkbox under [UNVETTED] is NOT checked. For the first half, I have this: =IFERROR(SMALL([BID AMOUNT]40:[BID AMOUNT]44…
    Unanswered
    10 0
    Question 10 views 0 comments Started by JeffG_WI
  • How best to copy partial information from one column into another?
    In Formulas and Functions
    I am using IF(ISBlank) and IF(Contains) together to automatically populate a a cell in one column from data in an adjacent cell/column, but the formula won't let me add any more combinations of the formula to complete this task for about 8…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by David Brandt
  • Formula in excluding weekends when adding number of dates in a formula cell.
    In Formulas and Functions
    Hi, I need help what is the formula for me to be able to create automatically a due date in a cell, based on the automatically created date column but I don't want to include weekends in the count. I wanted to set an automatic due date ba…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Genevieve P.
  • sheet summary and I need several formulas
    In Formulas and Functions
    I have a sheet summary and I need to have several formulas 1-How many requests total? =COUNT([Date Received]:[Date Received]) 2-How many requests from Group "A"-Group "B"? a) which has the most volume? …
    Unanswered
    17 0
    Question 17 views 0 comments Started by Bobby1
  • How to return email addresses for multiple contacts in a cell?
    In Formulas and Functions
    I have a column name Project Sponsor/ Owner with multiple contacts in the cell. In another column I have Project Sponsor Contact, which returns the email address for the sponsor. I created a VLOOKUP formula and it only found the email for …
    Tab Profile Photo Tab
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Genevieve P.
  • Nested IF formula with Multiple conditions
    In Formulas and Functions
    Hi, I am trying to create a formula in the status column and I keep getting an error message.  I wanted to make the status column a calculation to limit the amount of work the editors has to do.  I have never been great with nested if sta…
    Answered - Pending Review
    18 1
    Answered - Pending Review 18 views 1 comment Most recent by Emily Zeiger
  • Parse text from large string
    In Formulas and Functions
    @Paul Newcome - I've read a lot of your discussions throughout the years and you are the MAN! I have a question down below and hoping you can walk me through it. I'm simply not that good at this particular formula design. I have a SF Conne…
    Accepted
    33 5
    Accepted Answer 33 views 5 comments Most recent by Charlie.H
  • Change symbol based on date
    In Formulas and Functions
    Good morning Everyone,  I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which…
    409 6
    409 views 6 comments Most recent by Paul Newcome
  • AVG of ‘Days to Accomplish Task’ column, by ‘Assigned To’ column, by 'Completed' Month
    In Formulas and Functions
    Smartsheet Community, Trying to build a Key Performance Indicator Trend Analysis Metric Sheet to record the Average (within a given month) of ‘Days to Accomplish Assigned Task’ column, by ‘Assigned To’ column, by ‘Date Completed’ column Mo…
    Answered - Pending Review
    39 3
    Answered - Pending Review 39 views 3 comments Most recent by Paul Newcome