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
Check out the Formula Handbook template!