Crosssheet COUNTIFS with three parameters.
Answers

It should be possible. Can you provide the formula you currently have that isn't working?

So when I try to build the formula in one sheet to reference the other sheet, it only gives me the option of 2 variables. If I build the formula from scratch it gives me error.
=COUNTIFS({Master List Range 3}, "SA", {Master List Range 2, "FY 2020"}, {Master List Range 1}, "proposed"
I believe the problem is that since it does not give me the option to select more than 2 variables, it cannot identify which is range 1 and I have no way to tag the range.
Any help would be appreciated.

I got it. But thank you.

Great! Glad you were able to figure it out!

Could you share how you got it? I am having the same issue....

COUNTIFS has the syntax (criteria range1, criterion1, criteria range2, criterion2, criteria range3, criterion3, criteria range4, criterion4, etc). Just keep adding terms in that pattern. The helper text will show [range2, criterion2] generically for every term after criterion #1 the helper text will not change to show criterion#3, for example. See the countifs function document. https://help.smartsheet.com/function/countifs
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!