Formula Containing Two Separate Column Results

Deb Fuller

I am attempting to create a Smartsheet Summary field that contains a formula that provides the count of the number of risks I have in the risk column of a sheet combined with a status of not closed in a subsequent status column. This is the formula I have written but it is returning a parsing error:

=COUNTIF([Risk or Issue]:[Risk or Issue], ="Risk", [Status]:[Status], <>"Closed")

Any insight would be helpful.

Thank you in advance.

Mark Cronk

Hi,

Change to COUNTIFS. Try:

=COUNTIFS([Risk or Issue]:[Risk or Issue], ="Risk", [Status]:[Status], <>"Closed")

Work?

Mark

Mark Cronk

Hi,

Change to COUNTIFS. Try:

=COUNTIFS([Risk or Issue]:[Risk or Issue], ="Risk", [Status]:[Status], <>"Closed")

Work?

Mark

Deb Fuller

Hi Mark,

Worked beautifully! Thank you!