How to Count a Code in one Column when the Task is due Within a Time Period


Hi Community,

Looking for some assistance here I have a summary sheet where I am looking to perform some cost calculations. I want to pull the count of when cost code 1 is logged but only when the task happens before a date (Finish < a date) into the cell of another sheet

Here is my attempt: =COUNTIFS({LCM China Project Plan_example Range 0}@row < DATE(2023, 3, 1), 1, {LCM China Project Plan_example Range 1}, 1)


  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭

    Hmmm. If I understand what you're looking to do... try this...

    =COUNTIFS({LCM China Project Plan_example Range 0}, < DATE(2023, 3, 1), {LCM China Project Plan_example Range 1}, 1)

    Looks like you had too many pieces in there, but you were on the right track.

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!