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

  • Cells not multiplying correctly.
    In Formulas and Functions
    Hi, I have two adjoining cells that are not multiplying correctly. I have tried =[part qty] * [module type] and the formula returns "10" when it should return "20" I have tried =[part qty]@row 8 [module type]@row and …
    Accepted
    6 2
    Accepted Answer 6 views 2 comments Most recent by Mark Cronk
  • Approvals based on values in contact list containing more than one value
    In Formulas and Functions
    I have an approval process to ok team members to work on an additional project. I have a contact list column to enter which team members are being requested for a certain project. I need an approval that will fill in and gather approvals …
    Answered - Pending Review
    18 6
    Answered - Pending Review 18 views 6 comments Most recent by Jen Lange
  • Index/Match with two criteria: MATCH must use Search Type 1
    In Formulas and Functions
    Like the title says, I need to match on TWO criteria in an INDEX/MATCH function. The two lookup criteria are: 1) Phase (this one is straightforward) 2) largest value less than or equal to a given percent If I only needed…
    Accepted
    16 3
    Accepted Answer 16 views 3 comments Most recent by Mark Cronk
  • Combine two separate contact cells into one cell.
    In Formulas and Functions
    With the new update to Vlookup adding contact list functionality, would there be a way to combine two individual contact cells into one cell with both contacts using an equation/formula?
    706 10
    706 views 10 comments Most recent by pamela.moss89851
  • Move Rows Automation - I can't find the sheet I want to move all of my rows to?!
    In Formulas and Functions
    Hi All, I have a Smartsheet which contains client quotations. I want to build an automation that will move expired quotes out to a 'Cold Leads' Sheet so the main sheet just contains confirmed quotes. I want to target the automation so a ch…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by DMurphy
  • Metric from Report?
    In Formulas and Functions
    Is there a way I can display a metric from a report?
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by DMurphy
  • How do I apply a formula to an entire column?
    In Formulas and Functions
    I have a data sheet with a column labeled "DUE DATE". When someone submits a form I want the due date to automatically update to be two days from date of submission. I have it auto populating to current date, and know the formula…
    Accepted
    9 1
    Accepted Answer 9 views 1 comment Most recent by Streamline Technology
  • Bulk copy folder to list of users
    In Formulas and Functions
    Is there a way to bulk copy a Smartsheet folder to a specific list of users? The set of users is a mix of licensed and unlicensed.
    Answered - Pending Review
    6 2
    Answered - Pending Review 6 views 2 comments Most recent by Aprylli Bernarte
  • Set a default date on a form
    In Formulas and Functions
    We created a form from a sheet for data entry purposes. Is it possible to set a default date on the form? We have a date require field that we would like to default it to 10 business days from today()'s date.
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå
  • Cell link from report
    In Formulas and Functions
    Can you link a cell from a report to a sheet?
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå