-
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…
-
Has Children Function
Hi, I am trying to create a formula that will output the average of the child rows IF and ONLY if a line has child rows. If a line doesn't have child rows, I would like it to output (for example) the number "0" if the status column, Status@row, is "To Do" and "100" if Status@row is "Complete". Please let me know if there…
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
-
Formula Help
I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type]…