Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

Discussion List

  • 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 Formulas and Functions
  • 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 Formulas and Functions
  • Automation Setting
    In Using Smartsheet
    Hi All, I am trying to set up an automation for a reminder When Action Due Date is reach and all other actions due date that's in the next 30 days (or within that month) and status active, send an reminder email. I tried many times; howev…
    Emi Profile Photo Emi
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Mike TV Using Smartsheet
  • 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 Formulas and Functions
  • 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 Formulas and Functions
  • 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 Formulas and Functions
  • 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 Formulas and Functions
  • Using a form to sign up to conduct training
    In Using Smartsheet
    Hello, The process I am trying to create is as such: I need a way for two different levels of employees to be able to sign up to conduct training classes. The classes are mostly different for each employee level, but some overlap to both …
    Answered - Pending Review
    10 2
    Answered - Pending Review 10 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • 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å Formulas and Functions
  • SUM and INDEX combination formula
    In Formulas and Functions
    I have this formula that works in Excel, but when I try to rebuild it in Smartsheet, I'm getting an error that it's unparseable. How can I do this in Smartsheet: =SUM(C3:INDEX(C3:N3,$C$2)) I've gotten here in Smartsheet, but it doesn't wor…
    Accepted
    29 5
    Answered ✓ 29 views 5 comments Most recent by Jklay Formulas and Functions