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

At Risk Flag
Hello All, I'm trying to enable an at risk flag with the following criteria: Within 3 days of date to follow up if the status is either "open" or "deferred" ignoring any rows that have blanks for dates I've been searching the forum, I found one that worked, but flagged every empty row at risk because there were zero…
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
If, Then with a date and N/A
Hello, I'm attempting to put 3-4 arguments together. I can get 3 to work, but not the 4th. I have 3 columns: Letter Due, Letter Sent, and Sent in Window. The Yes, No, N/A are calculated for Sent in Window using the below formula =IF(AND(ISDATE([*Confirmation Letter Due*]@row), ISDATE([*Confirmation Letter Sent*]@row),…