Formula to Calculate items expiring in the next 10 days which are not closed yet

I am working on a formula on incident reporting to calculate items expiring in the next 10 days, where the status is not closed yet.

Can you advise if the following formula is correct?

=COUNTIFS({Expiry Date}, <=TODAY(10), {Status}, NOT(@cell = "Closed"))

I look at my sheet and there are only 2 items which are not closed and expiring in the next 10 days, but the calculation is showing 3. (1 item is expiring in next 10 days but already closed).

Would appreciate your feedback on this. Thanks.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!