Using References to pull info across sheets
![TedJ](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I'm new to Smartsheet, so I expect this to be an easy question. I'm using References to pull info across sheets and I need a cell count from the Category Column with an input of "Category 1" only if the Status Column in that row has an input of "Not Started". Here's a copy of my unsuccessful attempt.
=COUNTIFS({Project Status}, "Not Started", {Project Category}, "Category 1")
I get #Incorrect Argument Set error
Appreciate any help on this. Thanks
Best Answer
-
HUZZA,
OK, if you are having this issue, I will share one solution. On the sheet that I am pulling info from I picked an out of the way cell and wrote this formula,
=COUNTIFS([Project Status]:[Project Status], "Not Started", [Project Category]:[Project Category], "Category 1")
Then on the destination sheet I linked the cell that I needed this information, to the cell on the other sheet that I used to create that formula. It worked, although to get updated information on the destination sheet I have to "Refresh" it and the cells update with the info I need. Thanks
Answers
-
I used your formula and it seems to be working fine for me. That error message usually means an extra comma or missing comma for the function you are using.
...
-
Are you using Reference to pull info across sheets as indicated by the {} brackets in my formula. Asking because I've been at this for two days with no success.
-
HUZZA,
OK, if you are having this issue, I will share one solution. On the sheet that I am pulling info from I picked an out of the way cell and wrote this formula,
=COUNTIFS([Project Status]:[Project Status], "Not Started", [Project Category]:[Project Category], "Category 1")
Then on the destination sheet I linked the cell that I needed this information, to the cell on the other sheet that I used to create that formula. It worked, although to get updated information on the destination sheet I have to "Refresh" it and the cells update with the info I need. Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!