-
Multiple Time Stamp Measurements
Is there a way to have 3 timestamps per sheet and then have a formula calculate the difference? For example, think about an interview process. We need to capture File Received, File Touched, and Status Changed. Then we would want to measure how long it takes to go from received to touched, Touched to status change, and…
-
Auto numbering based on criteria and auto-reset
Hello! I'm trying to auto-number two columns (Cell Batch and Passage#) based on Project Code, Batch ID and Cell type. IF Project Code and Batch ID are different, increase Passage# by +1 for either HEK or CHO, if passage # is 33, then reset from 1. IF Passage# for HEK or CHO reach 33, then Batch ID +1 Note: HEK and CHO…
-
How can I track when a ticket is past its number of SLA days??
Hello, thank you in advance with helping with this question! Please see below: Situation: My team uses a Smartsheet intake form to take work requests from other teams. This populates into a sheet with the needed information to move tickets to different status' (ex: New Request, Active, Backlog, Triage Required). All of…
-
How to update automatic subject line when sending attachments
Hello! Is there a way to automatically change the subject line and contents of the message when sending attachments? When I send attachments from this sheet, I will want all of the subject lines and messages to be the same, but not what Smartsheet automatically populates the form with. Is there a way to change this text so…
-
I'm working on the template "Employee Pulse Check" template and need help with this formula.
I am working off of the "Employee Pulse Check" template but doing it for customers instead. I am changing the formula from this: =IF(ROUND(AVG([(Converted) Overall]:[(Converted) Overall])) = 0, "Strongly Disagree", IF(ROUND(AVG([(Converted) Overall]:[(Converted) Overall])) = 1, "Disagree", IF(ROUND(AVG([(Converted)…
-
Convert output of LEFT function to date
Hello, Couldn't find the answer already posted. I have a column that is a dropdown list of sprints where the format is the start date, end date, and sprint number all in one string. I would like to pull the start date out to use in another column to calculate end date based on the number of sprints. When I use the LEFT…
-
Seeking Formula output in ratio when conditions are met in other columns with dropdown selections
Hello, Here is another formula attempt for below table: I want to check if the % Complete is "Complete" and Standard is "I - Availability of Services" for the current row, is true, then I need the ratio of rows that meet both conditions to the total number of rows in the Standard column. Here is my attempt at the formula:…
-
Hi, I found that the vlookup, Index and even a simple reference cells which work in Excel dont work
How do I ensure the dates in the columns are autopopulated and the references in rows should be able to capture the successive dates in columns on formulae such as countif etc...
-
IF OR Formula Help!
Hello! I'm trying to put together a formula in the Posted To field pictured below, to return a result of either "Internal" or "External." The formula I'm using is below. =IF(OR([Portal Status]@row = "Posted", [ATS Posted]@row = "internal"), "Internal", "External") This formula returns an "Internal" result but I can't quite…
-
Formula is returning double counts when using COUNTIFS
Hi Smartsheet Community Forum, I'm trying to capture the number of studies that are ongoing and I am using a sheet that has a data column "BioA Data Sent". When a study is done, the date is entered into this cell. If a study is ongoing, then that cell is left blank. I also have another column with a checkbox for when a…