Cross-Sheet Formulas in Sheet Summary
Hello,
I am trying to do a cross sheet formula in one of my sheet summaries. I have done it when it only affects one column, but in the formula I am trying to do I need to include two formulas. Is it possible to select two columns from my sheet when cross referencing in sheet summary? I have copied my formula thus far. I am stuck on how to get the cross sheet information in there.
=COUNTIFS([Validation Type]:[Validation Type], OR(@cell = "Blue Badge"), Date:Date, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31))) +COUNTIFS(
The second part of the formula should almost mirror the first part, but it will be pulled from a different sheet. I will need the Date column and the Validation Type column from my other sheet. Is this possible to do?
I would appreciate any insight! Thank you!
Answers
-
Yes, you should be able to pull from two different cross sheet ranges. When prepping to choose your ranges select the "Reference another sheet" link in the help box when designing your formula.
-
I see how I can select multiple columns now, but I still can't my formula to work. This is what I am trying to pull. When I select multiple columns it pulls the first column I choose, last column I choose, and everything in-between. Do I need to pull the columns individually to make my formula work? Any advice?
=COUNTIFS({2020 Q4 Validations Range 1}, [Validation Type]:[Validation Type], OR(@cell = "Amazon"), Date:Date, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31)))
I would love some help! Thank you!
-
Yes, pull each column individually.
-
I am trying to do it this way:
=COUNTIFS({2020 Q4 Validations Range 2}, [Validation Type]:[Validation Type], OR(@cell = "Amazon"), {2020 Q4 Validations Range 3}, Date:Date, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31)))
I am getting #INVALID OPERATION. Any feedback?
Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!