Solution Center
Discussion List
-
Setting Formula using RYGIn Formulas and FunctionsHi! 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 views 5 comments 0 points Most recent by Heather Duff Formulas and Functions
-
ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATEIn Formulas and FunctionsI 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…
-
#NO MATCH result with INDEX/MATCH formula referencing Auto-Number/SystemIn Formulas and FunctionsI 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…
-
Vacation & Time-Off ManagementIn Using SmartsheetHas anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
-
Automated workflow trigger not workingIn Using SmartsheetI 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 views 6 comments 0 points Most recent by Earl Tessmer Using Smartsheet
-
CHANGE ON SITE AFTER IS CONFIRMEDIn Formulas and FunctionsI 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 views 10 comments 0 points Most recent by Christina.R Formulas and Functions
-
Complex nested IF, AND with traffic light symbolsIn Formulas and FunctionsHi 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…
-
CTRL + ] Does Not Indent, But Right Clicking DoesIn Using SmartsheetOur 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 (…
-
Pulling data into a "master sheet"In Formulas and FunctionsHello 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 views 6 comments 0 points Most recent by Eponine Formulas and Functions
-
Survey Help!In Using SmartsheetHello 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.