Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • How to pull rows from a different sheet only if they're marked as "in progress" ?
    In Formulas and Functions
    Hi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single c…
    Answered - Pending Review
    24 7
    Answered - Pending Review 24 views 7 comments Most recent by Marina Han
  • Reference an entire column and sync it with another column in a secodn sheet
    In Formulas and Functions
    Looking to take all 150 rows from a column in sheet 1 and sync them to sheet 2. Any changes to sheet 1 should be reflected in sheet 2.
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Andrée Starå
  • If i check this checkbox, then check another check box
    In Formulas and Functions
    I am looking for a formula that says... if i check this box on this sheet then go check another box on another sheet. What am i missing to make the 2nd box get checked when Purchased @ row 1 is checked? =IF([email protected] = 1, {other shee…
    Answered - Pending Review
    19 1
    Answered - Pending Review 19 views 1 comment Most recent by Andrée Starå
  • Sumifs formula help please
    In Formulas and Functions
    Trying to determine # of total hours if a specific program is listed. Seems simple but keep getting errors. Attempts below. Any thoughts? =SUMIFS({Team Range 9}, >0, ({Team Range 8}, FIND("Program", @cell) =true)) =SUMIFS…
    Accepted
    21 5
    Accepted Answer 21 views 5 comments Most recent by Paul Newcome
  • If Formula that Autopopulates names
    In Formulas and Functions
    Hi! I need help with a formula that would do the following...... If John Smith was a Client Services Director that was assigned to two states (AL and LA), which formula would I use to populate his name into the column adjacent to the stat…
    Accepted
    28 12
    Accepted Answer 28 views 12 comments Most recent by SK
  • Branding Update Requests
    In Formulas and Functions
    Can I add my logo to the update request so that they look similar to the automated alerts?
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by Scott Yohe
  • IF-WORKDAYS Calculation
    In Formulas and Functions
    I have a sheet with a [Request Submitted] column. Our SLA to attend to any received request is 2 business days. So I'd like to add a column that highlights any overdue items. My logic is: If TODAY is 2 business days past [Request Submit…
    Answered - Pending Review
    26 4
    Answered - Pending Review 26 views 4 comments Most recent by Guaca Mohle
  • Select a Value in Dropdown Cell Using IF Formula
    In Formulas and Functions
    I want the LabWare User Status cell value to be Pending if the checkbox in the Request LabWare Account cell is Checked. I've tried IF ([Request LabWare Account]@row = "Checked", "Pending") and a few other formula variat…
    Accepted
    46 10
    Accepted Answer 46 views 10 comments Most recent by Paul Newcome
  • How to extract an end date from a text string in a cell with a date range?
    In Formulas and Functions
    Hello, I am trying to extract an end date from a text string into a separate date cell in a separate date column. For example, in a cell with the following text string "1/1/14-6/30/22; 10,000,000 print and secure electronic" I wo…
    Accepted
    21 3
    Accepted Answer 21 views 3 comments Most recent by Paul Newcome
  • Numbers won’t add up on construction template?
    In Formulas and Functions
    It has to be easy? Or the way I copied and pasted? It’s the template for construction estimate? Some of my numbers won’t total-and the very top number for total for entire estimate won’t populate?
    Answered - Pending Review
    16 12
    Answered - Pending Review 16 views 12 comments Most recent by Andrée Starå