Discussion List

  • 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
  • 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(…
    63 3
    63 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
    199 6
    199 views 6 comments Most recent by Joseph Borthwick Using Smartsheet
  • 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…
    623 3
    623 views 3 comments Most recent by Stefan 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…
    185 3
    Accepted Answer 185 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Flag if date created > 48 hours and completed column is blank
    In Formulas and Functions
    Hello, I'm new to using SmartSheets and first time poster here. Hoping you can help me with an elegant solve? I'm trying to create a function where a row will be highlighted when it satisfies two criterias: 1. if the date created has bee…
    263 7
    263 views 7 comments Most recent by Mark Berger Formulas and Functions
  • RYGB symbols automated to reflect status/progress
    In Formulas and Functions
    Hi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what ne…
    447 12
    447 views 12 comments Most recent by Paul Newcome Formulas and Functions
  • Legal projects/task management sheet
    In Using Smartsheet
    Hi,  I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all…
    1188 13
    1.2K views 13 comments Most recent by Andrée Starå Using Smartsheet
  • Add RTF (rich text formatting) to Comments
    In Using Smartsheet
    When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF fu…
    294 6
    294 views 6 comments Most recent by Tucker Webb Using Smartsheet
  • Is it possible to use QR codes in Smartsheet to track inventory?
    In Using Smartsheet
    I have a project that requires tracking inventory and instead of barcodes we are looking at utilizing QR codes. Does anyone know whether it is possible to use the Barcode Inventory Management template that is available in Solution Center b…
    326 3
    Accepted Answer 326 views 3 comments Most recent by Andrée Starå Using Smartsheet