Discussion List

• Change Milestone Diamond Color

  In Using Smartsheet

  Hi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀 

  Rachel Shen

  04/25/22

  Answered - Pending Review

  35 1

  Answered - Pending Review 35 views 1 comment 0 points Most recent by Andrée Starå 04/25/22Using Smartsheet
• Trying to identify cells in ALL CAPS vs Title Caps

  In Formulas and Functions

  I have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they can be corrected - is this possible?

  SarahA

  04/22/22

  Accepted

  34 4

  Answered ✓ 34 views 4 comments 0 points Most recent by SarahA 04/22/22Formulas and Functions
• Smartsheet Forms - Displaying View Only Fields

  In Using Smartsheet

  We have a SS Form that we are using to collect Project Go-Live Confidence for that month. The Form provides the PM with the Project Mgr Name, Project Name and Current Go-Live Date along with conditional questions. We want some of those f…

  Carolynh

  04/22/22

  Accepted

  39 7

  Answered ✓ 39 views 7 comments 0 points Most recent by Carolynh 04/22/22Using Smartsheet
• Conditional formatting with formulas

  In Using Smartsheet

  Is it possible to conditionally format a cell where based on the answer to one cell the formatted cell changes its formula?

  Mitchkalning

  04/21/22

  2524 12

  2.5K views 12 comments 0 points Most recent by dovrosenberg 04/21/22Using Smartsheet
• Equation to populate new number

  In Formulas and Functions

  Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last co…

  SYDPEN

  04/19/22

  Accepted

  18 4

  Answered ✓ 18 views 4 comments 0 points Most recent by Jeff Reisman 04/19/22Formulas and Functions
• SUMIF multi-condition syntax

  In Formulas and Functions

  a Coworker and I have been banging our heads on this one for a couple weeks now for a project under development. We're trying to SUM hours {TotalTime} within a date range that meets a label criteria (@cell, Month16). It actually works unti…

  MikeLowry

  04/19/22

  Answered - Pending Review

  33 3

  Answered - Pending Review 33 views 3 comments 0 points Most recent by Paul Newcome 04/19/22Formulas and Functions
• Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started

  In Formulas and Functions

  Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started). This is what I had: =IF([email protected] = "Completed", "Green"…

  M.Q.

  04/18/22

  Accepted

  21 2

  Answered ✓ 21 views 2 comments 0 points Most recent by M.Q. 04/18/22Formulas and Functions
• Workaround for Voting

  In Using Smartsheet

  Hello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have…

  Elisa Rustenbach

  04/14/22

  Accepted

  667 8

  Answered ✓ 667 views 8 comments 0 points Most recent by Kyle Thompson 04/14/22Using Smartsheet
• Filter to show only dates from this week???

  In Formulas and Functions

  I'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?

  vforte40

  04/11/22

  1564 22

  1.6K views 22 comments 0 points Most recent by Suzanne Raphael 04/11/22Formulas and Functions
• How to alert regarding a duplicate value within a row?

  In Formulas and Functions

  Hi I would like to add some sort of alert or conditional formatting, but I'm not sure how to accomplish this. For the columns impacted they are all dropdown single select columns. I want some sort of alert, could be as simple as highlighti…

  Amber Angon

  04/11/22

  Answered - Pending Review

  39 7

  Answered - Pending Review 39 views 7 comments 0 points Most recent by Genevieve P. 04/11/22Formulas and Functions