Want to do an IF/AND but not skilled enough to make it work

edited 11/01/21 in Formulas and Functions

=COUNTIFS([Proposed Finished Year]1:[Proposed Finished Year]22, 2022, [Strategic Initiative]1:[Strategic Initiative]22, "Revenue Growth")

COUNTIFS({Sheet - Project Requests Range 2}, Primary35)

Trying to tie the two formulas together to count each initiative (there are 5) in rows and only for 2022.


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Judith

    There are two different formulas here, one looking cross-sheet and one looking in-sheet. Can you clarify a little more what you're looking to do?

    If you're looking for an overall count, adding together both sheets, then you can use + to do something like this:

    =COUNTIFS([Proposed Finished Year]:[Proposed Finished Year], 2022, [Strategic Initiative]:[Strategic Initiative], "Revenue Growth") + COUNTIFS({Proposed Finished Year - Sheet 2}, 2022, {Strategic Initiative - Sheet 2},"Revenue Growth")

    If I've misunderstood your set-up, can you explain what this formula is looking at:

    COUNTIFS({Sheet - Project Requests Range 2}, Primary35)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!