-
Sigma Level Formula
Good afternoon, Wondering if anybody knows how to enter the following formula that we use in Excel: =NORMSINV(1-(total defects / total opportunities))+1.5 into Smartsheet, we use it to calculate Sigma Levels. Thanks!
-
Sum column from form submissions
I have users inputting data using a form. The data comes into my sheet at the top. At the bottom of my sheet I have a cell that is summing the numbers in a column called "Sales Amount". Each time a new record is added at the top however the formula summing the "Sales Amount" is not being included. My formula is…
-
Formula Question
Good Morning. I am attempting to create a forumula which references another sheet; however, I continue to receive error messages or it doesn't calculate correctly. Below is the outline of what I am looking to accomplish. Let me know if you can help. One column called Program with drop down options of Service Expansion,…
-
Formulas...CountIfs I believe
In process of creating a formula and I can't seem to get it to work correctly. Any feedback is welcome. I have two columns. Both are drop downs. Column Program: A, B, C Column Status: A, B, C, D, E Would like to create a formula that will count how many A's are in Program column WHEN Status column is b, c, or d All…
-
Check if a row is parent and starts with "abcde"
Hi, Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".
-
Help with fuzzy match formula
I have no idea how the program thinks that the number 2 even approximately resembles the word "Sparks Corp". I want to use fuzzy math to find the closest vendor name to the one that is typed in, and was hoping to use the approximate match, but am having a hard time understanding what the program believes is approximate. I…
-
Counting Projects that are 1 Week or More Behind Schedule
Hi Everyone, I got a great formula from Customer Success that I thought I would share. I wanted a way to know if a project was at least 1 week or more behind schedule. This is what Customer Success gave me: =COUNTIFS(Finish:Finish, TODAY() <= TODAY(-7), [% Complete]:[% Complete], <>1) This formula counts tasks that are 7…
-
IF statement formula needing help
I'm needing help completing a formula. The formula that is needed will look specific data in column "A" then specific data in column "B" with the result of these to coming from a different little grid. I've got the 1st (A & B) correct but can't seem to get the 3rd criteria to pull correctly. =IF(ISBLANK([column 1]3:[column…
-
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
-
Formula Counting Courses Required /Taken
All, Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this smartsheet I am trying to find a formula that will show me when they have completed all courses that they are required. The…