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

  • Two new PPM Functions: Successors and isCritical, available now!
    In Formulas and Functions
    Hi Community,  We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical.  The Successors function (type: numeric) allows users to calculate the direct successors of a task…
    473 2
    Announcement 473 views 2 comments Most recent by Patti Petitclerc
  • Nest If/Or with Contains
    In Formulas and Functions
    So with multiple drop downs I want the HC Froup to result in either one of three returns: backfill, backfill repuposed, or new. I am getting an uparseble error. Following is a snapshot of the attempt
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Kelly Moore
  • Trimming all spaces
    In Formulas and Functions
    Hi, I am trying to apply a formula so that when meta data is input it is automatically trimmed to have zero spaces, which I know how to do in excel but does not seem to work in smartsheet. So, I have a column where we input license plates,…
    Unanswered
    8 0
    Question 8 views 0 comments Started by BradJoseph
  • Bulk Updates
    In Formulas and Functions
    Hi, I have multiple sheets that is getting data with formulas from one specific sheet that gets updated 3 times a week. I'm calling this sheet as the bulk update sheet. Since SmartSheet doesn't allow to import from excel on that particular…
    Unanswered
    8 0
    Question 8 views 0 comments Started by Cemil Binlik
  • I have one column Miles and a second column Billable miles.
    In Formulas and Functions
    MILES BILLABLE MILES (RESULTS) IF miles is > 1 miles -500, if miles < 500 "N/A"
    GLW Profile Photo GLW
    Answered - Pending Review
    8 2
    Answered - Pending Review 8 views 2 comments Most recent by GLW
  • Basic checkbox counting to apply status option to Parent rows only
    In Formulas and Functions
    I am unable to get the output to say "Not Started" in the Status column for the formula I am using. What is missing? Also, is there a way to reference "Done" part of the Children of the parent without specifying the exa…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Mike TV
  • Using Countif in place of Autonumber - formatting question!
    In Formulas and Functions
    I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Mike TV
  • Counting values within multi selection dropdown column
    In Formulas and Functions
    I used a multi selection dropdown column to select each company that sent in a bid for that project and I want to keep track of the total number of bids sent for each company. The formula I used is COUNTIF({Architect Selection}, "BSA&…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Mike TV
  • Index/Collect that should work, but is not returning values.
    In Formulas and Functions
    Hello, Community! I've tried support and Pro Desk so far without success and could REALLY use your collective brain power. Here's the situation: I'm trying to use Index/Collect to bring the value of A into D where the Year for Role = 0 and…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Mike TV
  • Return ALL ID#s from another sheet if other Sheet equals "specific name"
    In Formulas and Functions
    Hello Everyone, I am brand new to using smart sheets. I have a lot of experience us PBI but not as familiar with the smartsheet formula writing. I have a completely blank sheet and also a roster sheet with ID numbers and location names. Wh…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Mike TV
  • How can I get rid of rows that are not applicable?
    In Formulas and Functions
    I am creating a report with any upcoming tasks that are due within the next 14 days. However, when I do that, it pulls in my entire sheet, even rows that are in the future and not within the next 14 days. How can I get this to only show ta…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå