I need help to complete this formula

Weston Johnson
edited 04/05/24 in Formulas and Functions

=COUNTIFS({Sunbelt Life Cycle TC tracker Range 1}, "Complete")

I need to pull in this data but I need to pull it between certian dates ex.. 4/1/2024 and 4/30/2024 can some one help me please

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    Do you have some type of date column you can use for reference? Depending on how your sheet is setup, it would look something like this:

    =COUNTIFS({Sunbelt Life Cycle TC tracker Range 1}, "Complete", {Date}, @cell >= DATE(2024, 04,01), {Date}, @cell <= DATE(2024, 04, 30))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!