COUNTIF date is this month

I'm trying to create a summary to only total projects that were added to my portfolio this month. I've got this formula to work in excel, but I can't get it to work in smartsheet. For reference, I'm a pro user.

Excel formula:

=COUNTIF(B2:B9,">="&DATE(2022,2,1))

Smartsheet formula:

=COUNTIF({Added to Portfolio},">="&DATE(2022,02,01))

Thoughts?

Tags:

Answers

  • Summer
    Summer ✭✭✭
    edited 02/14/22

    Hi @Paula D , One approach would be to create a helper column that converts your "Added to Portfolio" date column into the month associated with that date.

    Be sure your "Added to Portfolio" column properties is DATE and then in your Helper Column next to it add the formula =MONTH([Added to Portfolio]@row)

    You can convert the formula in the "Month Added" Column to a column formula and then hide it so you don't have to actively manage it when new rows are added and to keep your sheet clean.

    Your Count if formula would be

    =COUNTIF([Month Added]1:[Month Added]11, =MONTH(TODAY()))

    Or if you want the month to be static you could just reference the numerical representation of the month. In this example Feb = 2

    =COUNTIF([Month Added]1:[Month Added]11, 2)

    To select the entire column as the range, remove the numbers at the end of the column name ref.

    =COUNTIF([Month Added]:[Month Added], 2)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!