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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 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!