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 …
    133 4
    133 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…
    61 3
    61 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Join Collect
    In Formulas and Functions
    Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet.  Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeep…
    103 3
    103 views 3 comments Most recent by David Joyeuse Formulas and Functions
  • Gantt chart that overlays multiple projects
    In Using Smartsheet
    We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a …
    243 views 2 comments Most recent by James Robitaille Using Smartsheet
  • Smartsheet to Word Document
    In Using Smartsheet
    One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transfo…
    514 5
    514 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • 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…
    1320 25
    1.3K views 25 comments Most recent by remkin Formulas and Functions
  • Email User Completed Form
    In Using Smartsheet
    I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address.  I would like to create workflow automation when a certain trigger has taken pla…
    91 3
    Accepted Answer 91 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • COUNTIF in Sheet Summary
    In Formulas and Functions
    I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")  
    73 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Sheet exceeded the maximum recommended size
    In Using Smartsheet
    Has anyone received this error message before?  What are the options for large data?   (Image)
    324 views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Ranking Tasks
    In Using Smartsheet
    I work in the IT Department at a company. Another department assigns tasks to our department for software support for a particular application that they use. We would like for them to rank the tasks that they want us to complete - with num…
    51 views 6 comments Most recent by hollywallace Using Smartsheet