Change <60 Days to search by month

Options
tgattsh
tgattsh ✭✭✭✭
edited 03/08/24 in Smartsheet Basics

So I have this formula which searches the past 60 days.

=COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Pictures", {18b Issues Range DT}, AND(@cell >= TODAY() - 60))

I want to change it to search my date range {18b Issues Range DT} and show everything in the month of Jan 2024. How would I change this? Any help would be appreciated!

Tags:

Best Answer

  • tgattsh
    tgattsh ✭✭✭✭
    Answer ✓
    Options

    Oh That's easy. Try this...

    =COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row))

    Happy to help...

Answers

  • tgattsh
    tgattsh ✭✭✭✭
    Answer ✓
    Options

    Oh That's easy. Try this...

    =COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range Issue1}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 2}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 3}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row)) + COUNTIFS({18b Issues Range Installers}, [Installer Code]@row, {18b Issues Range 4}, ="Meter Configuration", {18b Issues Range DT}, AND(MONTH(@cell) = Month@row))

    Happy to help...