Discussion List

• 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…

  Tomer

  01/26/20

  1447 13

  1.4K views 13 comments 0 points Most recent by Andrée Starå 01/26/20Using 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…

  Dantawn

  01/19/20

  365 6

  365 views 6 comments 3 points Most recent by Tucker Webb 01/19/20Using 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…

  Deanna Vandermeer

  12/20/19

  Accepted

  397 3

  Answered ✓ 397 views 3 comments 0 points Most recent by Andrée Starå 12/20/19Using Smartsheet
• At Risk Flags

  In Formulas and Functions

  How do I format my At Risk column so the flags only appear in the "children" rows, as shown in the screenshot?

  mel_berk

  12/08/19

  361 3

  361 views 3 comments 0 points Most recent by Andrée Starå 12/08/19Formulas and Functions
• Is there a way to automatically add an entry on a monthly basis?

  In Using Smartsheet

  Hi, all. I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this? Thanks!

  Bret Linford

  12/03/19

  57 9

  57 views 9 comments 0 points Most recent by Andrée Starå 12/03/19Using Smartsheet
• Embed countdown in Smartsheet

  In Using Smartsheet

  I would like to embed a countdown for Go-Live into my project dashboard. Any idea? 

  [email protected]

  12/03/19

  2305 6

  2.3K views 6 comments 0 points Most recent by Andrée Starå 12/03/19Using Smartsheet
• Is There Really No Built-in Log\NL Function?

  In Archived 2017 Posts

  My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…

  Michael.Baker

  12/01/19

  273 2

  Closed 273 views 2 comments 0 points Most recent by Ford 12/01/19Archived 2017 Posts
• Date Modified - Copy of column creates different date

  In Formulas and Functions

  Hello,  I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized as a date field I created a copy of th…

  EPayne

  11/20/19

  374 7

  374 views 7 comments 0 points Most recent by Andrée Starå 11/20/19Formulas and Functions
• Help with a Formula

  In Formulas and Functions

  I have a Target % Complete column in a project plan template that essentially looks to see if you are tracking to the % complete you should be based on today's date and the start and end date of any task (or tells you that you are missing …

  LLaCosta

  11/20/19

  33 3

  33 views 3 comments 0 points Most recent by Genevieve P. 11/20/19Formulas and Functions
• VLOOKUP #INVALID DATA TYPE Challenge

  In Formulas and Functions

  Hi!  I'm new to the community and already raising an issue.  Sorry about that!  If anyone can help me with this, I'd greatly appreciate it.  I'm trying to use VLOOKUP within a Product Roadmap sheet to set the values of the feature start d…

  bscruggs

  11/19/19

  476 3

  476 views 3 comments 0 points Most recent by Mike Wilday 11/19/19Formulas and Functions