Support

Discussion List

  • Trying to fix the start date of a subtask with no dependency
    In Using Smartsheet
    I trying hard code the start of a sub-task (4th level indent). When I try the start dates always comes back to the start date of the task of the previous indent. I would like to have my sub-task with no dependency to start much later (har…
    Unanswered
    6 0
    Question 6 views 0 comments Started by Sylvain Legare Using Smartsheet
  • Is there a way to create a search box?
    In Formulas and Functions
    We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
    501 11
    501 views 11 comments Most recent by Reni Viessmann Formulas and Functions
  • Array formulas
    In Formulas and Functions
    Hi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to per…
    315 views 15 comments Most recent by Paul Newcome Formulas and Functions
  • Forms with formulas
    In Formulas and Functions
    I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back th…
    1348 13
    1.3K views 13 comments Most recent by Andrée Starå Formulas and Functions
  • Days Lapsed/Column Formula
    In Formulas and Functions
    How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it s…
    Accepted
    12 1
    Accepted Answer 12 views 1 comment Most recent by Mike Wilday Formulas and Functions
  • Lookup To Return Multiple Results
    In Formulas and Functions
    Hi - I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to…
    Answered - Pending Review
    28 7
    Answered - Pending Review 28 views 7 comments Most recent by Genevieve P Formulas and Functions
  • How do i track progress based on output?
    In Formulas and Functions
    I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadshee…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Sam Harwart Formulas and Functions
  • I will send you $100 USD if you can help me solve this
    In Using Smartsheet
    Hi there, If you can help me solve this, I will send you $100 USD via Paypal. My company generates leads for car dealerships across Canada. We will be using Smartsheet for our dealer partners to manage the leads we assign them. Each deal…
    Answered - Pending Review
    37 3
    Answered - Pending Review 37 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • If function for children rows
    In Formulas and Functions
    Hi all, I don't know how to build a formula for the following: I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row …
    Accepted
    22 2
    Accepted Answer 22 views 2 comments Most recent by Bas Hoogeveen Formulas and Functions
  • Getting Started
    In Using Smartsheet
    Does anyone know how to contact Smartsheet directly, I am on a trial version, I have sent numerous email requests, customer support forms etc. with no response. Is this normally how smart sheet runs? Should I look for different providers t…
    Answered - Pending Review
    12 4
    Answered - Pending Review 12 views 4 comments Most recent by Ben Jackson Using Smartsheet