Column Formula pulling from 2 Columns on 2 Sheets
Answers
-
Hi Everyone,
I want to create this same logic from an archive sheet that has the same columns as in the second sheet. So, the first criteria does not allow the formula to run. Any Suggestions?? is it because they are the same??
thank you for the help!
-
@Natalia Nino Try changing the opening curly bracket inside of the red box to an opening square bracket.
{ to [
-
Hi Paul
I changed it but still the same Error.
=COUNTIFS({Carrier Project Range 2}, "Complete", {Carrier Project Range 3}, [Category task]@row) + COUNTIFS({Archive-Change Request Range 1}, "Complete", {Carrier Project Range 3}, [Category task]@row)
What else do you think it could be.
Thanks for your help
-
It looks like your second COUNTIFS is referencing two different sheets - an Archive sheet in the {first reference} but a different sheet (the same one from your first COUNTIFS) in the {second reference}, "Range 3".
You'll want to ensure that the same sheet is being referenced within the parentheses of a COUNTIFS(__). Does that make sense?
Try deleting out the {Carrier Project Range 3} reference from your second COUNTIFS and insert a new reference going to the Archive sheet as well.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!