Referencing multiple sheets in 1 cell
![Laura G](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi
I am trying to make a metric to show on our dashboard how many Initiated and Overdue project statuses we have. I have created a metrics sheet for this.
I am trying to count how many times Initiated appears in a status column from 3 sheets. Error is showing "incorrect argument set". What am i missing?
Thank you
Best Answers
-
Your first example is the closest but you are missing a few ) and then have two where they should not be. I've tried to highlight in bold here. If you edit the formula in smartsheet the parentheses are color coded so you can see the pairs and where there are spares.
Each COUNTIF should have a ( then the range then a comma, then criteria, then )
=COUNTIF({Connection Agreements Range 1}, [Primary Column]12) + COUNTIF({Licences / Permits Status}, [Primary Column]12) + COUNTIF({PPA Compliance Register status}, [Primary Column]12) + COUNTIF({Rules Range 1}, [Primary Column]12)
-
Happy to help!
Answers
-
Hey there @Laura G
The COUNTIFS function is looking for a row where all the criteria are met. So the three columns need to be on the same sheet. If you want to COUNT when Col 1 in sheet 1 = Initiated and Col 1 in sheet 2 = Initiated and Col1 in sheet 3 = Initiated then you could use COUNTIF and add the three COUNTIFs together.
=COUNTIF({Licences / Permit Status},[Primary Column]@row)+COUNTIF({PPA Compliance...},[Primary Column]@row)+COUNTIF({Rules Range 1},[Primary Column]@row)
-
Hi KPH
I have tried these 2 scenarios but it didn't work for me. Do you know what I am missing? Thank you
=COUNTIF({Connection Agreements Range 1}, [Primary Column]12 + COUNTIF({Licences / Permits Status}), [Primary Column]12 + COUNTIF({PPA Compliance Register status}, [Primary Column]12 + COUNTIF({Rules Range 1}), [Primary Column]12))
=COUNTIF({Connection Agreements Range 1}, [Primary Column]12, COUNTIF({Licences / Permits Status}), [Primary Column]12, COUNTIF({PPA Compliance Register status}, [Primary Column]12, COUNTIF({Rules Range 1}), [Primary Column]12))
-
Your first example is the closest but you are missing a few ) and then have two where they should not be. I've tried to highlight in bold here. If you edit the formula in smartsheet the parentheses are color coded so you can see the pairs and where there are spares.
Each COUNTIF should have a ( then the range then a comma, then criteria, then )
=COUNTIF({Connection Agreements Range 1}, [Primary Column]12) + COUNTIF({Licences / Permits Status}, [Primary Column]12) + COUNTIF({PPA Compliance Register status}, [Primary Column]12) + COUNTIF({Rules Range 1}, [Primary Column]12)
-
Thank you so much! That worked!
-
Happy to help!
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