Summary formula Sum of information

David Clunie

David Clunie ✭✭

11/30/21 edited 11/30/21 in Formulas and Functions

Hi All

Can anyone please advise on how to quantify two columns in the Summary information?

I want to look at the failure column to look for keywords then sum the amount of failed items.

Example look for ...

OTIF and the sum of issues should report 10

Tags:

Formulas

0 ·

Answers

David Clunie ✭✭

11/30/21

Already have it sorry, unless this is not correct?

=SUMIF(Failure:Failure, "OTIF", [Failed Items]:[Failed Items])

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

Help to identify all x.x.1 cells
I have a WBS column that I'm joining with a resource row count to provide a distinction for tasks not just by hierarchy but by resource. I need to be able to exclude the very first task per assignee in the first hierarchy only. How do I identify only the x.x.1 tasks in a column? I need to create a formula for all RBS =…
Flagging dates overlap
Hi Smartsheet stars, I try to flag jobs overlaps using COUNTIFS function as per screenshots below (tried two different options), however, it doesn't show me 3 overlaps I currently have in my Smart sheet (I created a new A and AAA projects with conflicting dates but it has not been flagged for some reason). Could you please…
Trying to get an accurate count of checked boxes in a report
hi there, I am trying to get my report to only count boxes checked in each row. instead, it is counting the checked and unchecked boxes, which doesn't translate into my dashboard report. Is there a way to make sure it only counts check boxes for each summary?