Trying to count the same status from two sheets - Getting unparssable error

keesuri25

=COUNTIFS([Engagement Phase]:[Engagement Phase],CONTAINS ("DIAGNOSTIC (CALL SETUP)”,@cell), {DoD Status}, CONTAINS ("DIAGNOSTIC (CALL SETUP)”,@cell))

Genevieve P.

Hey @keesuri25

If you're looking at two different sheets, you'll want to use two separate formulas, then add them together with th + sign.

For example:

=COUNTIFS(formula sheet 1) + COUNTIFS(forumla sheet 2)

I also noticed you have some quotes which are angled, like so: ” instead of ". Smartsheet will need the quotes to be straight up and down: " not ”. Try typing them right into the cell, this will make sure it's the right type of quote!

Here's how I would adjust your formula:

=COUNTIFS([Engagement Phase]:[Engagement Phase], CONTAINS("DIAGNOSTIC (CALL SETUP)", @cell)) + COUNTIFS({DoD Status}, CONTAINS("DIAGNOSTIC (CALL SETUP)", @cell))

Cheers,

Genevieve

Genevieve P.

Hey @keesuri25

If you're looking at two different sheets, you'll want to use two separate formulas, then add them together with th + sign.

For example:

=COUNTIFS(formula sheet 1) + COUNTIFS(forumla sheet 2)

I also noticed you have some quotes which are angled, like so: ” instead of ". Smartsheet will need the quotes to be straight up and down: " not ”. Try typing them right into the cell, this will make sure it's the right type of quote!

Here's how I would adjust your formula:

=COUNTIFS([Engagement Phase]:[Engagement Phase], CONTAINS("DIAGNOSTIC (CALL SETUP)", @cell)) + COUNTIFS({DoD Status}, CONTAINS("DIAGNOSTIC (CALL SETUP)", @cell))

Cheers,

Genevieve

keesuri25

Thank you @Genevieve P. - Worked like a charm :)

Genevieve P.

No problem! I'm glad to hear it 🙂