Countifs(OR

Robert S Fike
Robert S Fike ✭✭✭✭
edited 05/08/24 in Formulas and Functions

All parts of this works on its own, but cant figure out how to make them work together.

=IF($Help$1 > April$1, COUNTIFS({888 - Job Progress Slab}, <=DATE([Help Lot Size]1, April1, 31), {888 - Job Progress Final CO}, ="", {888 - Job Progress Origination Note}, ="Spec", COUNTIF({888 - Job Progress Final CO}, OR(@cell >= DATE([Help Lot Size]1, April1, 31), @cell = "")), COUNTIF({888 - Job Progress Contract Date}, OR(@cell >= DATE([Help Lot Size]1, April1, 31), @cell = ""))), "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!