What formulae touse to get the count of status of A In Progress/Not Started and the same for B

Answers

  • COUNTIFS({ADSP Reliability Engineering Goals Range 2}, [AdPT SVP]1, {ADSP Reliability Engineering Goals Range 3},=Not Started)

    This is what i was trying to use

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Pritam Roy Chowdhury

    You're close! Any time you're searching for text, such as Not Started, you'll need to wrap it in quotes: "Not Started".

    Try something like this:

    = COUNTIFS({ADSP Reliability Engineering Goals Range 2}, [AdPT SVP]@row, {ADSP Reliability Engineering Goals Range 3}, "Not Started")

    Where:

    • {Range 2} is looking at the Goal Hierarchy column
    • [AdPT SVP]@row is the cell in the current row that identifies either "A", or "B", etc
    • {Range 3} is looking at the Status column
    • "Not Started" or "In Progress" are the values you're searching for


    See: Create and Edit Formulas in Smartsheet

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!