Hi, Can someone help me with using @row within my COUNTIFS formula?

Options

The formula I'm using is: =COUNTIFS({OKS Satellite Accumulation Area Inspection Range 3}, "A-1", {OKS Satellite Accumulation Area Inspection Range 5}, "No") For some reason, when I add @row to both ranges, it comes back as unparseable

Thanks

Answers

  • Michael Culley
    Michael Culley ✭✭✭✭✭
    Options

    @row doesn't seem to make sense here. It looks like you're using a cross-sheet reference. What your countifs should do is search an entire column (I'm assuming thats the "OKS Satellite Accumulation Area Inspection Range 3") and look for "A-1", then it searches another entire column "OKS Satellite Accumulation Area Inspection Range 5" and looks for a "No". That's what it's counting.

  • DonC33
    DonC33
    edited 10/04/22
    Options

    Hi Michael,

    Yes, you are correct in you assumptions. Would there be a better option? I have multiple locations that are being inspected for multiple parameters

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!