CountIF
Paul Molloy
✭✭✭✭
Hi all
this formual does not seem to work and cant figure out why? I am looking to find how many projects in the "Install progress" column and not complete and expected to completed before 01/01/2021.
=COUNTIF([Install progress]:[Install progress], >"Complete": [Expected Comp Date]:[Expected Comp Date], < "01/01/2021")
thanks ;)
Best Answer

try:
=countifs([Install Progress]:[Install Progress], "Complete",[Expected Comp Date]:[Expected Comp Date], < DATE(2021,01,01)
Answers

try:
=countifs([Install Progress]:[Install Progress], "Complete",[Expected Comp Date]:[Expected Comp Date], < DATE(2021,01,01)

Thanks Jenna 😁
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!