How can use the Countifs function with the Today function in the formula?

Hello,

I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days.

Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <= TODAY(-30))

I am creating the formula on a separate sheet than the one with the information. I can post the two test sheets that I am currently using to figure this out before applying it to the actual sheets.


Thank you.

Best Answer

Answers

  • Hi @Genevieve P

    Thank you for your help. Your formula worked. I needed to add the end date.


    Kind Regards,

    Johnathon

  • Glad to hear that it worked for you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!