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

  • I need to collect the average of a column by referencing name in another column
    In Formulas and Functions
    I have columns in a sheet per the screen below. The Team Member is input through a form submission and can potentially be input many times. I am looking for a formula to collect the average score from all rows where one name appears withou…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by [email protected]
  • Is there a way to automatically add two sheets data into one new sheets as parents and childrens row
    In Formulas and Functions
    Hi, I was wondering is there a way to bring two smartsheets data into one automatically. Smartsheet A datas will be the parent row in Smartsheet C, and Smartsheet B will match the smartsheet A data and automatically added into Smartsheet C…
    Answered - Pending Review
    25 5
    Answered - Pending Review 25 views 5 comments Most recent by Christina Lam
  • Counting a row if due date is >= 2 weeks from TODAY()
    In Formulas and Functions
    Hi All I was wondering if anyone has been able to come up with a formula to count a row if the column due date is a certain amount of days from "today". I want to add a backlog tracker to my dashboard but I can't seem to come up …
    Accepted
    12 1
    Accepted Answer 12 views 1 comment Most recent by Chris Walker
  • Create a formula based on time
    In Formulas and Functions
    Good day...I am wondering if there is a formula that can bring back results based on time for example today()-created row brings back days...can I bring back hours or minutes?
    Accepted
    16 3
    Accepted Answer 16 views 3 comments Most recent by John Littler
  • Sheet Summary Formula
    In Formulas and Functions
    Good afternoon, Starting to try and better understand how to write formulas. I am trying to count the sum of the "BAE"column if my "Product Division" column has - Structural Shop Team - in it but it is coming back as #…
    Accepted
    11 5
    Accepted Answer 11 views 5 comments Most recent by Andrée Starå
  • Report or formula to show time individual cell was changed?
    In Formulas and Functions
    We would like to be to see when (timestamp) changes are made to individual cells in a row without having to manually check cell history for the cell(s) of interest. Is there a formula we can use to do so? Or is there a report we can export…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Andrée Starå
  • Return a Contact from another Sheet based on value
    In Formulas and Functions
    Hello, I have a source sheet (Sheet A) that maintains a list of projects and assignments. I need a second request sheet (Sheet B) to intake requests. On this sheet, the project name will be included. I would like to use a formula to outp…
    Answered - Pending Review
    14 3
    Answered - Pending Review 14 views 3 comments Most recent by Leibel S
  • Conditional Formatting not working as expected.
    In Formulas and Functions
    Hi, Excel: 2016 Version. I am creating conditional formatting dynamically from VBA with the below code every time when I opened my excel. The rules are getting created, but they are not highlighting the max and min value in a row (conditio…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Bvsn. Kiran
  • Parent/Child Lines to be populated from Form
    In Formulas and Functions
    I would like to create a form that allows for Parent information to be completed and populated and where applicable allow for child data to be entered and applied to that parent data. Example: Form User Enters Main Task and Description …
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Andrée Starå
  • COUNTIFS Contains but Not Contain
    In Formulas and Functions
    I have a multi-select column that contains both the options Pending and Pending Registration. I want to count if the Contract Status column contains Pending but not Registration. Here's what I have so far... need help. =COUNTIFS({Contra…
    Accepted
    25 4
    Accepted Answer 25 views 4 comments Most recent by KDM