I want to create a formula to reference 2 columns in another sheet.
HI. I am looking to create a formula that will reference another sheet called Minor Issues Log. I want to record in my sheet if a full NCR was required by referencing the column "Is a full NCR required" and searching for "yes" and also reference a second column the other sheet called "Area / Dept". The end result i am looking for is a list of how many Minor Issues went on to require a full NCR against each department. The formula i have so far is =COUNTIF({Minor Issue Log Range 3}, "Yes", AND({Minor Issue Log Range 2}, "Mould")), but this is returning #INCORRECT ARGUMENT SET. Can anyone help please?
Best Answer
-
Hi everyone.
The formula that finally worked was =COUNTIFS({Minor Issue Log Range 3}, "Yes", {Minor Issue Log Range 2}, "Mould")
Thanks
Answers
-
Try
=COUNTIFS({Minor Issue Log Range 3}, "Yes", ({Minor Issue Log Range 2}, "Mould")
-
Hi Paul. Thanks for the suggestion. I have put this into the sheet and it comes out with #UNPARSEABLE
-
Hi everyone.
The formula that finally worked was =COUNTIFS({Minor Issue Log Range 3}, "Yes", {Minor Issue Log Range 2}, "Mould")
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!