Sheet Summary Help - IF Status and Date greater than

Good morning,

I am trying to displat a Metrix on a Dash. I am using a sheet summary. Is it possible to write a formula that would show only items entered in 2021? The sheet goes back to 2016.

IF Status = Complete And Date greater than 12/31/2021

Currently the formula is: =COUNTIF(Status:Status, "Complete") but this shows over 4000+ orders.

Thank you in Advance.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!