IF Formula with Nested COUNTIFS and Last 365 Days

Sam H.
Sam H. ✭✭✭
edited 03/01/23 in Formulas and Functions

Hello. I am working on a formula to calculate how often an Account Number (Nominee C#) appears in a column. If it appears more than once, then a box gets checked. I have this part built and working, but now I need to add an additional parameter to only checkmark the box if they have appeared more than once in the last 365 days.

Here's what I currently have without the 365 days parameter: =IF(COUNTIFS([Nominee C#]:[Nominee C#], [Nominee C#]@row) > 1, 1, 0)

Any idea how to add that additional 365 day parameter in?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!