Company Management

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…
    1425 5
    1.4K 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…
    7946 22
    7.9K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • Update Columns in Existing Row Using Forms
    In Using Smartsheet
    Hello, I have a sheet where I am tracking construction progress.  There are a lot of data/calculations that my field personnel do not need.  I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.)  Each…
    1314 9
    1.3K views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Dashboard access via link not showing the user as logged in.
    In Using Smartsheet
    So, I am having an issue with my published dashboard. I have embedded a report utilizing the current user function. I have found that when my team accesses the dashboard by manually navigating to it through SmartSheet, the report works per…
    141 3
    141 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Smartsheet not saving consistently
    In Using Smartsheet
    I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
    1251 12
    1.3K views 12 comments Most recent by Bec Nissen Using Smartsheet
  • Formula to count of items in a multi dropdown list
    In Formulas and Functions
    Hi The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion).  I want to count how many times a value is repeated in a range that has multi values. I use …
    Accepted
    26605 42
    Accepted Answer 26.6K views 42 comments Most recent by Paul Newcome Formulas and Functions
  • Format as time
    In Using Smartsheet
    I need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not…
    90 4
    90 views 4 comments Most recent by Sheryl Roland Using Smartsheet
  • 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…
    4972 30
    5K views 30 comments Most recent by JeremiahHorstick API & Developers
  • Bulk Removal of Users
    In Using Smartsheet
    Hello, Just wanting to check if there's a way of bulk removing of Smartsheet users? I know you can bulk upload contacts/users into Smartsheet but need to know if you can do the same by removing. The reason for this is to avoid a long wind…
    Accepted
    77 3
    Accepted Answer 77 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Seeking consultants
    In API & Developers
    We're an organisation responsible for government facilities management, asset management and projects . We currently use Smartsheets but require refined and custom built business solutions to assist in business operations. We're seeking ex…
    Answered - Pending Review
    56 3
    Answered - Pending Review 56 views 3 comments Most recent by Darren Mullen API & Developers