Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Can you help with a counting formula question?

Hi - I'm trying to create a count if formula that will include Bid Stage from one column and either of Open or On Pause criteria from another column. 

This is what I tried =COUNTIFS({2020.3.31 Antitrust MA Subgroup Chart Range 2},"Bid Stage", [{2020.3.31 Antitrust MA Subgroup Chart Range 1}, "Open", {2020.3.31 Antitrust MA Subgroup Chart Range 1}, "On Pause"])

I appreciate any help you can provide. Thank you!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions