Wholesale Distribution

 

Discussion List

  • 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…
    1332 5
    1.3K 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…
    7555 22
    7.6K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    4505 30
    4.5K views 30 comments Most recent by JeremiahHorstick API & Developers
  • Use DISTINCT with COUNTIFS
    In Formulas and Functions
    Hey Guys! I am so excited to see that Smartsheet has finally introduced a formula that will compute DISTINCT(Unique) values!!  So, I am trying ot develop a formula to calculate DISTINCT count using one column but with a few condition(s) …
    875 5
    875 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Automatically Track Inventory Usage
    In Formulas and Functions
    I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program.  I'm hoping there's a way to automatically track inventory usage base…
    583 7
    583 views 7 comments Most recent by Alexander Coales Formulas and Functions
  • Arrange meetings from within SmartSheet
    In Using Smartsheet
    Hello, Is it possible to arrange a meeting from within SmartSheet - instead of using Outlook. That way one could send a meeting invitation where the SmartSheet document would be an attachment similar to Outlook process.   Thanks, Sigu…
    SHE Profile Photo SHE
    633 5
    633 views 5 comments Most recent by tylermh Using Smartsheet
  • Day of Week instead of short date
    In Formulas and Functions
    Hello,   I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the …
    922 4
    922 views 4 comments Most recent by radix Formulas and Functions
  • Document Management Systems
    In API & Developers
    Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
    302 4
    302 views 4 comments Most recent by Brianne Laird API & Developers
  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    123 3
    123 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Attachment in an online Form
    In Using Smartsheet
    Hello, I have creeated an online form but I need that people can add an attachment (image). Anyone knows if this is possible and how?  I guess it is possible as this form I am filling in has  this feature. Thanks you for your help Ugo …
    4515 12
    4.5K views 12 comments Most recent by Andrée Starå Using Smartsheet