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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!