How do I account for a specific status in a formula calculating expiration status?

I am using the following formula to count the number of contracts that are expired

=COUNTIF([Contract Expiration Date]:[Contract Expiration Date], <TODAY())

I want to exclude any contracts that have "Archived" (Value) as the "Current Status" (Column) from this count.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!