Metrics on Multi-Select with multiple criteria?

Options
MGBUSA
MGBUSA
edited 11/30/23 in Formulas and Functions

QUESTION How to calculate uptime based on Multi-select

Good afternoon.

I tried many things, and am still unable to accomplish the following:

  • a) Sum a duration column
  • b) When the duration is ">0"
  • c) AND the "Incident Type" = "Outage"
  • d) AND the "Impacted System" matches either "DW" or "BYOD"
  • e) if the multi-select cell contains both matching values, only sum it once

The following was my last attempt at simplifying the formula to try to figure out how to do 'd).

Any advice is appreciated.

=1- (SUMIF([Impacted System]:[Impacted System], HAS(OR(@cell, "DW", @cell, "BYOD")), [Incident Duration]:[Incident Duration]))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!