Countif Formula to include Flags

Options

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!

Tags:

Answers

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!