Discussion List

  • TimeStamp Formula Value
    In Using Smartsheet
    Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match …
    4013 8
    Accepted Answer 4K views 8 comments Most recent by Andrée Starå 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…
    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…
    7945 22
    7.9K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • Proofing - Exporting Markup
    In Using Smartsheet
    Hello All,    Is anyone aware of a way to export proofing comments and markup? Currently, I have to take screen shots of the file and the comments to compare with the previous version and use for archiving purposes. Thanks for the assis…
    404 10
    404 views 10 comments Most recent by itsnotbroken Using Smartsheet
  • Sorting Favorites
    In Using Smartsheet
    Hello - Is there a way to sort order of the items that appear in the Favorites section?  I don't see the 'Pin to Top' option in Favorites and do not see a way to drag sheets to the top that I would like to appear first. Thanks!
    315 5
    315 views 5 comments Most recent by Werner Using Smartsheet
  • Email address (mailto: link) in Dashboards
    In Using Smartsheet
    Hi -  Have there been any updates on being able to enter an email address (mailto: link) in Dashboards. I would like to add Key Contacts for the project in a Rich Text Widget and include links to emails for those contacts.  I've tried bu…
    2796 18
    2.8K views 18 comments Most recent by Matt Cass Using Smartsheet
  • 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 …
    330 4
    330 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…
    133 3
    133 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Formula to return the logged in user
    In Formulas and Functions
    Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODA…
    913 6
    913 views 6 comments Most recent by Genevieve P. 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…
    198 3
    Accepted Answer 198 views 3 comments Most recent by Andrée Starå Using Smartsheet