-
Auto filling quote number column using automations?
I want my quote number to auto populate a quote number only when a new job row (parent row) is added. We use the quote number NV25-0xxx (ex: NV25-0258, NV25-0259). Multiple clients requesting the same job go in children rows, the children rows get the same number as the parent row so I do not need new quote numbers(I added…
-
Left Function
In the Left function, is there a way to grab just the letters, not another character, such as a dash? I have a column of numbers that include 2-3 letters, a dash, a number, dash, then 1-3 letters. Example: XX-10000-WQA, XXX-10000-WQA. I would like to have a column that just shows the first 2-3 letters, without the dash, if…
-
Formula to Calculate Percentage Change from Baseline
Hi, We capture scores between 1-5 each month. I'm looking to create a formula to calculate the percentage change from the baseline based on the most recent month's entry in that row. For example, baseline (starting) score was 3 in June (captured in the column "June"). Let's say it's now August and the score is 4 (captured…
-
Calculating average with various criteria that need to be met first
I have never completed an AVG formula yet, and I am looking at past posts, and i cant find something close to what I am looking for. I have criteria it needs to meet, before it can calculate the Average Must contain English Must contain NDC Must contain Open Must Contain 'ALL' Then i need it to take all the data in the…
-
Need help with a couple Formulas for On hold and Certain Counts
First formula - In a sheet, in sheet summary I need a formula to count the instances certain Project Channels show up. There are three that will need to be counted. For now let's just call them Channel 1, Channel 2 and Channel 3. They are a dropdown column. Second formula - same thing-same sheet and sheet summary formula.…
-
Column Formula Possibility
I am looking to create a column formula to subtract the bottom score (Q1-Score) from the one in the line above if the values in the Survey Identifier field are the same (the formula would be going in the Q1- Dif column). Right now I have the formula below which works as a drag and drop field but I would like it to be a…
-
Formula Assistance
If in a sheet our project settings call out workdays and holidays. do we need to add workday or holiday in our formulas still to take those days out?
-
New reference range in a metrics sheet is not working.
This one has me baffled. I have added a row to a large sheet. I notice it does not show up in any of my metrics calculations after the add. In my metrics sheet, I refer two ranges in another sheet: {All Action Items Status1} and {All Action Items Resp Org Map}, which exist as a reference ranges. My original formula for…
-
Cannot convert to column formula to save my life...
I have two columns: Days Open and Turnaround, depending on "Status". I have tried so many ways to convert these to column formulas and Smartsheet will not let me. A lot of folks will be using this sheet so I'd rather not rely on everyone dragging down the formulas if I can help it. I've created a sheet with literally just…
-
Help with cross-sheet automation and formulas
I have 2 separate sheets to manage my team's assignments. One is a weekly assignments sheet that pulls from a partner request form and a daily assignment sheet where I manually assign tasks and priority level to each assignment. I want to make it so that when I assign Tier 1 or Tier 2 priority on the 2nd sheet, it…