or Explore Discussions

# 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…
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. …
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 …
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…