Discussion List

  • Data hosting services within Canadian border
    In ENGAGE Conference
    Anyone know vendors who can host the data within Canada to meet contractual requirements, since we have datasets built with Smartsheet and running Dynamicview, we are looking for ways to meet the contractual obligations to host the data wi…
    68 0
    68 views 0 comments Started by jjebamani ENGAGE Conference
  • Sales pipeline with sort (need child/parent row stays together)
    In Using Smartsheet
    I have a sheet that has child/parent rows and which I can sort by dropdown list order (see below pics) So here are my questions: 1.) how can I have a report where it only shows the current user AND that the child/parent row are together wh…
    Answered - Pending Review
    31 7
    Answered - Pending Review 31 views 7 comments Most recent by Genevieve P. Using Smartsheet
  • Center of Excellence
    In Using Smartsheet
    If someone wants to subscribe to the Center of Excellence, can he/she do that without being a paid Smartsheet user, or does the person need to upgrade?
    1179 5
    1.2K views 5 comments Most recent by Genevieve P. Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1587 5
    1.6K views 5 comments Most recent by L_123 Formulas and Functions
  • Auto fill a second column based on a drop down selection using a form
    In Formulas and Functions
    I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.  Situation: I would like to have a form where someone selects one op…
    8542 22
    8.5K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • Conditional quantities for pricing sheet?
    In Formulas and Functions
    Smarties, I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2…
    48 4
    Answered ✓ 48 views 4 comments Most recent by BrianT Formulas and Functions
  • Score formulas
    In Formulas and Functions
    We are having a sales contest this month. The teams (Houses) entered their numbers and we are ready to Identify the winners for 1st, 2nd and 3rd place. I was able to identify the 1st place score (Highest Score) using the MAX function and t…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Charts Plotting 0
    In Using Smartsheet
    I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values fr…
    939 14
    939 views 14 comments Most recent by Paul Newcome Using Smartsheet
  • Cross Sheet reference/"assigned to" allow multiple contacts per cell LIKE formula?
    In Formulas and Functions
    SS community - I need help. I have created a Sales Pipeline sheet for my sales team, sales stages etc which is basically it's own CRM. I am trying to gain metrics in order to keep the sales team members honest and report the truth to the l…
    167 6
    167 views 6 comments Most recent by jwilson970216 Formulas and Functions
  • Pricing: A La Carte Apps
    In Apps, Integrations, and Add Ons
    Smartsheet, you need you allow apps to be added a la carte to Business accounts. Restricting apps to Enterprise is unnecessary. It feels like nothing more than hard-ball sales tactics. While Smartsheet has helped our business organize our…
    32 2
    Answered ✓ 32 views 2 comments Most recent by Genevieve P. Apps, Integrations, and Add Ons