Formula Containing Two Separate Column Results

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.

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi,

    Change to COUNTIFS. Try:

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

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!