I am trying to pull from my contracts management sheet, the number of "Executed" contracts that have a "Y". For background info, the "Y" denotes the last and active executed contract in a series. I don't want it to count all multiple executed contracts/amendments just the most recent one.

=COUNTIFS({Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4},"Y")

This is my formula and it worked perfectly ending at "Executed" until we made the "Y" Change and I had to update the formula. Now of course its not working.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!