Solution Center

Discussion List

  • Setting Formula using RYG
    In Formulas and Functions
    Hi! I'm trying to set up a formula using the Red, Yellow, Green symbols but I'm having difficulty doing so with how we use it. So basically, we have multiple columns we use to grade our employees in a QA setting so example Red=No, Yellow=S…
    Answered - Pending Review
    36 5
    Answered - Pending Review 36 views 5 comments Most recent by Heather Duff Formulas and Functions
  • ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATE
    In Formulas and Functions
    I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another sheet is feb/3/22, so under Citrix Status 3…
    Accepted
    79 13
    Answered ✓ 79 views 13 comments Most recent by Rob_PM Formulas and Functions
  • #NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
    In Formulas and Functions
    I use the INDEX/MATCH formula across many of my sheets for many years. This is the first year I've encountered this issue: my formula is indexing information referencing an auto-number system column type. We generate 3-digit "referenc…
    Accepted
    99 4
    Answered ✓ 99 views 4 comments Most recent by Megan Ryzenga Formulas and Functions
  • Vacation & Time-Off Management
    In Using Smartsheet
    Has anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?  
    3855 16
    3.9K views 16 comments Most recent by latkinson Using Smartsheet
  • Automated workflow trigger not working
    In Using Smartsheet
    I have set up a series of simple workflows to change a cell's value based on data in another cell. If the source cell value is changed to "50%" for example, the destination cell will automatically be updated with the number 5. …
    Answered - Pending Review
    248 6
    Answered - Pending Review 248 views 6 comments Most recent by Earl Tessmer Using Smartsheet
  • CHANGE ON SITE AFTER IS CONFIRMED
    In Formulas and Functions
    I have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I would like when I choose from Equipment …
    Answered - Pending Review
    45 10
    Answered - Pending Review 45 views 10 comments Most recent by Christina.R Formulas and Functions
  • Complex nested IF, AND with traffic light symbols
    In Formulas and Functions
    Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity compl…
    729 9
    729 views 9 comments Most recent by Ola123 Formulas and Functions
  • CTRL + ] Does Not Indent, But Right Clicking Does
    In Using Smartsheet
    Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (…
    307 11
    307 views 11 comments Most recent by Moriturusse Using Smartsheet
  • Pulling data into a "master sheet"
    In Formulas and Functions
    Hello all, I am trying to pull select data from multiple sheets into one "master sheet", however I am struggling to find a working method. I am unable to use reports due to them not connecting with datashuttle. I have tried VLOOK…
    Answered - Pending Review
    62 6
    Answered - Pending Review 62 views 6 comments Most recent by Eponine Formulas and Functions
  • Survey Help!
    In Using Smartsheet
    Hello All! I need your help! I need to send out a survey via email where I need employees to rank 10 different topics in a 1-10 format.
    Accepted
    35 1
    Answered ✓ 35 views 1 comment Most recent by Genevieve P. Using Smartsheet