Unusual Calculation

Options

Below is the formula I am using and it is giving me a value of 0 but should never give a value below 1. Any ideas on why it would give a 0?

=COUNTIFS([Oracle Id]:[Oracle Id], [Oracle Id]@row, Week:Week, Week@row, [Eval #]:[Eval #], [Eval #]@row)

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    @ker9 is correct - I've had this happen before with values that start with 0. Try using an @cell = in front of your criteria, this fixed it for me last time.

    =COUNTIFS([Oracle Id]:[Oracle Id], [Oracle Id]@row, Week:Week, Week@row, [Eval #]:[Eval #], @cell = [Eval #]@row)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!