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

  • Using Today formula in date field has limitations
    In Formulas and Functions
    Hi. I just wanted to find out if perhaps the =today() function does not work when using a sheet with begin and end dates and dependencies enabled. When I try to enter the function, it only shows the actual function statement and not today'…
    81 2
    81 views 2 comments Most recent by Paul Newcome
  • Multi Formula/Sheet Help
    In Formulas and Functions
    Hi  Been struggling with this for ages, I can get the two elements of this formula to work separately but not together - I hope the below makes sense! :) I am trying to get a formula to: A) Search a column on another sheet to see if a r…
    WSC Profile Photo WSC
    12 3
    12 views 3 comments Most recent by Paul Newcome
  • If statements with multiple conditions
    In Formulas and Functions
    Hi, Hoping someone can help with a formula I am struggling to get to work for a specific scenario. I have a "phase column" in my project plan which looks at various parent rows for my project phases, i.e Discovery, Design, Build…
    551 2
    551 views 2 comments Most recent by Paul Newcome
  • Last Working Day of the Month
    In Formulas and Functions
    I have been wracking and wrecking my brain trying to figure out a formula that will go ahead and automatically display the date of the last work day of the month taking into account weekends and holidays that will automatically calculate b…
    673 10
    673 views 10 comments Most recent by Paul Newcome
  • Adding time durations as actual numbers
    In Formulas and Functions
    Hello, We're trying to use Smartsheet to report on music details.  It would be very useful to take the durations of music tracks (formatted either as mm:ss or h:mm:ss) and add them together together for a total duration.   How would we at…
    552 11
    552 views 11 comments Most recent by Paul Newcome
  • Showing Errors in a formula
    In Formulas and Functions
    When working with a formula, some errors do happen and the formular doesn't work. Does smartsheet have a feature like excel which would show a part of formular that is missing something or has a problem? Also in excel, before you hit Ente…
    13 2
    13 views 2 comments Most recent by J. Craig Williams
  • Importing Excel Spreadsheet with embedded formulas
    In Formulas and Functions
    Does anyone know if you can import a Excel spreadsheet into SmartSheet with embedded formulas and formulas linked to other sheets in the same Excel file without having to re-create the formula within SmartSheet?
    1K views 4 comments Most recent by J. Craig Williams
  • Why doesn't this SUMIFS working?
    In Formulas and Functions
    I get #unparseable.   =SUMIFS(Effort Hrs:Efford Hrs,Assignee:Assignee,"Easton",Sprint Week:Sprint Week,"32") Effort Hrs = Hours worked Assignee = the person Sprint Week = the wee it is done  
    21 7
    21 views 7 comments Most recent by Dano
  • Using INDEX/MATCH to create sheet with subset of data from another sheet
    In Formulas and Functions
    I have a sheet that lists hundreds of inventory items. The sheet has columns with checkboxes indicating if a given item is included in a specific shipment type. I'd like to create a new sheet that populates a list of the inventory item num…
    531 1
    531 views 1 comment Most recent by Shaine Greenwood
  • Excel Formula Error
    In Formulas and Functions
    Hi All,   I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1)))) T…
    12 4
    12 views 4 comments Most recent by IamRachal