Formula for Lower control limit.

Aaron2323

Aaron2323 ✭✭

03/14/24 in Formulas and Functions

I am using =UPPER(STDEVP(A:A)) for the Upper control limit but cannot generate formula for lower control limit. Trying to create an SPC Chart for the data collected.

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

03/19/24

Are you able to provide some screenshots for context?

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula in Smartsheet that will tell me if the data in 4 different columns is the same
I am looking for a formula in smartsheet that will tell me if the data in 4 different columns is the same. In excel I am able to use =COUNTIF(A3:D3,A3)=4 In Smartsheet I am getting "INVALID COUMN VALUE"
Formula to summarize data from symbols column for same row ID
This discussion was created from comments split from: Countifs formula with and/or criteria across multiple columns.
Formula to count active projects if dates are not equal?
For project tracking we have an original end date and an actual end date. At the beginning of a project the dates would be equal, if there is slippage and the date is different we would update actual end date to the new end date. We have a dashboard with a widget that shows the count of projects where the end date changed.…