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 ✭✭✭✭✭✭

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
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

Trending in Formulas and Functions

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Equation help

Answers

Help Article Resources

Categories