Count within last 30 days if a specified value

Hi!

Could someone offer me some help with my formula below please?

I need to count how many rows have a date within the last 30 days in column 'Timestamp', and have a value above 8 in column 'NPS', and have a certain name in column 'Centre':

=COUNTIFS({Feedback mastersheet Range 1}, <=TODAY(30), {Feedback mastersheet Range 2}, >8, {Feedback mastersheet Range 3}, "CENTRE NAME HERE")

This is being used in a secondary sheet, hence the references back to the mastersheet.

Would be really grateful for any help! :)

Thanks

Oscar

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @Oscar Maynard

    I believe the below is what you are looking for:

    =COUNTIFS({Feedback mastersheet Range 1}, AND(@cell <= TODAY(), @cell >= TODAY(-30)), {Feedback mastersheet Range 2}, @cell>8, {Feedback mastersheet Range 3}, "CENTRE NAME HERE")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!