Countifs with with percentages

edited 12/09/19 in Formulas and Functions

What am I doing wrong?  The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. Any thoughts are greatly appreciated!



=COUNTIFS({C. *Ground Lease Tower In Air Date}, >=TODAY(), {C. *Ground Lease Tower In Air Date}, <=DATE(2019, 12, 31),({Ground Lease Probability Column}, >.49))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!