Countif Formula to include Flags
Hello,
I have a cross-sheet formula pulling in dates and other data from various sheets; however, I can't figure out how to count if the column contains a flag.
The formula is summing all new hires who have a status containing "push".
=IF(Level@row < 2, SUM(CHILDREN()), IF(Level@row = 2, COUNTIFS({New Hire Push List - Offer Start}, [Offer Start Date]@row, {New Hire Push List - Onboarder}, Onboarder@row, {New Hire Push List - Start Status}, CONTAINS("PUSH", @cell))))
I want to copy over this formula and pull in all new hires who have been pushed more than once, with is indicated by the red flag in another column.
=IF(Level@row < 2, SUM(CHILDREN()), IF(Level@row = 2, COUNTIFS({New Hire Push List - Offer Start}, [Offer Start Date]@row, {New Hire Push List - Onboarder}, Onboarder@row, {New Hire Push List - Duplicate Candidates}, --- contains flag, or is not blank, or???
Thanks!
Answers
-
I am almost 100% certain that flag symbol types are basically 1's or 0. So you can work in whether or not your flag column = 1. If you want items with flags, or flag column = 0 if you don't.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!