Countifs with with percentages

KO_in_Colo
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))

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!