I need help creating a formula that pulls information from two columns.
Hello All.
I need help creating a formula from two columns on one sheet and pushed to the summary sheet/dashboard with the totals.
The first column is a drop down menu for the order status (New, Processing, Billing, Completed, and Cancelled) and the second column contains a check or is unchecked. I am counting the drop down menu list with the unchecked rows. I have tried several of the formulas shared in previous discussions, but none have worked. I am only getting errors with the formats I have used so far.
Thanks,
Tammy
Answers
-
Hi @tschmidt
It sounds like a cross-sheet COUNTIFS should work for you! A COUNTIFS Function is structured like this:
=COUNTIFS({Column 1}, "Criteria 1", {Column 2}, "Criteria 2")
In your case, the first criteria would be the Status, and the second criteria is that a box is not checked, or is 0.
For example:
=COUNTIFS({Column with Status}, "New", {Checkbox Column}, 0)
Or, if you have a Status column in your current metric sheet:
=COUNTIFS({Column with Status}, Status@row, {Checkbox Column}, 0)
See: Cross-sheet formulas
Another option would be to create a Report with a filter that the box is unchecked, the Group the Report by the Status and use the Summarize function to count those sections. See: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Need more information? 👀 | 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
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!