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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!