Hi all, I'm not very privy with formulas, but am attempting to learn. I'm working on keeping track of square footage production based on "in progress" or "completed" in a manufacturing setting. There are 6 different steps to each unit produced (on different lines, see screen shot), and I'm trying to figure out a way to calculate the totals of each specific step. I'm assuming SUMIFS would be the correct route, but any help would be useful. In the past I would individually pick each cell for a =SUM(, but I've learned there's a limit of 200 or so. I'm hoping to avoid having to do this again

Try this... =SUMIFS([Task SF in Progress]:[Task SF in Progress], Task:Task, "Fr. Sh.", Status:Status, OR(@cell = "In Progress", @cell = "Completed"))

That goes back to the Completed vs Complete. Your formula is looking for "Completed", but the Status in row 28 is "Complete". Which means it is probably also not picking up row 20 either.

Equation help

Answers

Paul Newcome Community Champion

03/19/20

Haha. EVERYONE runs into that problem eventually when dealing with these types of metrics. I know about it and still do it very regularly.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
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

Trending in Formulas and Functions

Combine two IF formulas
Can someone kindly help me combine these two formulas? It's too complicated for the AI formula generator. :) =IF(MONTH([Global Trade Compliance Approval Date]@row ) = 1, "January", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 2, "February", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 3, "March",…
Trying to search 1 column of % to correspond with the column next to it. First % less than 100%
I am trying to search this column for rows 11 through 19 starting top and working towards the bottom and once a cell has a % in it less than 100% i want it to reference the cell in the column next to it. I have a formula that works if its 0% but not anything less than 100%. Formula that works for 0% - =INDEX([Task…
Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in the…

Equation help

Answers

Help Article Resources

Categories