Using References to pull info across sheets
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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!