COUNTIFS

Jason F

Good afternoon all!!

First time poster on here and still learning my Smartsheet.

Stumped on the formula and looking for some assistance.

I'm trying to count the checkboxes in the 2 columns on the sheet below, SUG Scheduled and SUG Completed.

What I am trying to do is count it each column for each similar column for the sheet below, separated by fleet type.

So for example on the second image, I want it to display for 73N SUG Scheduled, that 6 boxes are checked on Sheet1.

Thank y'all in advance!

Paul Newcome

Give this a try:

=COUNTIFS({SUG Requests Fleet}, @cell = 737, {SUG Scheduled}, @cell = 1)

Paul Newcome

What is your current formula that is throwing the error?

Jason F

This is the current formula I entered which is giving me an unparse. I still have not been able to integrate to recognize by each fleet.

Genevieve P.

Hi @Jason F

I believe what Paul is asking for is the actual formula copy/pasted that you're trying to use... for example:

=COUNTIFS({Fleet Column Reference}, Fleet@row, {SUG Scheduled Column Reference}, 1)

Cheers,

Genevieve

Jason F

@Genevieve P.

I had forgotten to paste the formula.

=COUNTIF[(SUG Requests Range 3), {SUG Scheduled}:{SUG Scheduled}, =1]

Paul Newcome

Give this a try:

=COUNTIFS({SUG Requests Fleet}, @cell = 737, {SUG Scheduled}, @cell = 1)

Jason F

I got it figured out. It was giving me an invalid ref but I realized I had the sheet references in wrong.

Thank you very much @Paul Newcome

Paul Newcome

Happy to help. 👍️