Discussion List

  • 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 …
    132 4
    132 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…
    64 3
    64 views 3 comments Most recent by Brianne Laird 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…
    1.6K views 16 comments Most recent by Michael Humenansky API & Developers
  • Parent Row % Complete Doesn't make any sense
    In Formulas and Functions
    See attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me.  There is a formula for Target % complete: =IFERROR(…
    31 3
    31 views 3 comments Most recent by Genevieve P Formulas and Functions
  • Can I have rows in card view?
    In Using Smartsheet
    I'm trying to determine if rows can be included / added on card view. I have my lanes setup to view by status (ie not started, in progress, blocked, complete, etc) but would like to have rows also to separate my cards by team or possibly a…
    PEZ Profile Photo PEZ
    54 6
    54 views 6 comments Most recent by Joseph Borthwick Using Smartsheet
  • 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…
    3388 19
    3.4K views 19 comments Most recent by Andrée Starå Formulas and Functions
  • COUNTIF by MONTH in Sheet Summary Field
    In Formulas and Functions
    Hello, I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Month() function from the Created field in…
    102 3
    102 views 3 comments Most recent by Stefan Formulas and Functions
  • Extract Image using Index and Match/Vlookup
    In Formulas and Functions
    Hey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't…
    52 1
    Accepted Answer 52 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • VLOOKUP to another sheet using images
    In Formulas and Functions
    I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the ima…
    271 views 12 comments Most recent by Andrée Starå Formulas and Functions
  • Calculate the time between two dates by days, hours and minutes
    In Formulas and Functions
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    1298 25
    1.3K views 25 comments Most recent by remkin Formulas and Functions