Help with formula referencing another sheet
I have a sheet titled Vendor Risk with a column called Inherent Risk with ratings High, Moderate and Low.
I have created another sheet that I want to use to store the COUNTIFS to count the number of vendors that were rated High, Moderate and Low.
I have tried using the help bubble with COUNTIFS and I select Reference Another Sheet, but it keeps coming back as unparsable. Can someone help with the correct syntax?
Best Answers
-
NVM - I figured it out
=COUNTIFS({Inherent Risk Range 1}, "High")
-
Hi @capenancy
I'm glad you figured it out! Since you only have one range and criteria you could use a COUNTIF instead (singular), but the COUNTIFS (plural) will work just as well. Plus if you wanted to add another range and criteria it will be easy to adjust.
Cheers,
Genevieve
Answers
-
NVM - I figured it out
=COUNTIFS({Inherent Risk Range 1}, "High")
-
Hi @capenancy
I'm glad you figured it out! Since you only have one range and criteria you could use a COUNTIF instead (singular), but the COUNTIFS (plural) will work just as well. Plus if you wanted to add another range and criteria it will be easy to adjust.
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!