How do I create a formula that covers two sheets ?
Hi,
I currently have this formula in use and I'd like to include one more sheet. How do I do that? Thank you!
=COUNTIF({Master Data - National (Atten how did you hear)}, Label14)
Tags:
Answers
-
Hi Irina,
If I'm understanding what you want to do the answer is to add additional COUNTIF statements. Along the lines of:
=COUNTIF({Master Data - National (Atten how did you hear)}, Label14) + COUNTIF({2nd sheet range}, Label14) + COUNTIF(3rd sheet range}, Label14)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!