How to combine formulas in a single string
Hi I am trying to count data using cross sheet references and a countif formula. I have 13 different sheets, thus will need to have 13 different countif formulas in a single string. In Excel, + works, but does not appear to work here. How can I combine formulas in a single string?
Best Answer
-
The issue in the screenshot is in the second COUNTIFS. You have your closing curly bracket } misplaced after "@row}" when it should be at the end of the cross sheet reference "Range 1}"
Answers
-
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Sure, "+" does not seem to work. I have 13 different sheets that are different sessions for an event. An employee can register for any of the 13 sessions, thus appear in any of the 13 sheets. I want to be able to count/capture the employee if they are in any of the 13 sheets.
So my thoughts are that using a countif (i actually used COUNTIFS, though not needed) formula to count how many times the employee appears in any of the 13 sheets (it should only be once).
Here is the formula with cross sheet references to only 2 sheets:
Here is the error received:
Ultimately, i'm trying to ensure I can capture if an employee is registered for any session, thus i would need to "check" for that employee's email address in each of the 13 sheets.
-
The issue in the screenshot is in the second COUNTIFS. You have your closing curly bracket } misplaced after "@row}" when it should be at the end of the cross sheet reference "Range 1}"
-
That solves it! Thank you.
-
Happy to help. 👍️
-
Thanks Paul! You are the master.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K 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
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives