Countifs Cross sheet reference
I found this similar issue and used the answer to fix my problem, but it didn't work for me.
=COUNTIFS({Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4}, "A&E")
However, I am getting a 0 return which I know is not correct. The column that has the program type "A&E", is a dropdown list. Would that affect the formula?
Answers
-
Hi AliT
I do not know why your formula does not work, but according to my test, "COUNTIF with the dropdown list criteria range with the same formula does.
Please take a look at this dashboard.
https://app.smartsheet.com/b/publish?EQBCT=08dbf58d299f489bb5a9e56f1430b961
-
Thank you for running the test. I am stumped as to why my formula is not working. Everything in your test, matches what I have. So odd.
-
jmyzk_cloudsmart_jp!!
One of my references was pointing at the wrong column! Once I fixed that, it is working now!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives