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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!