Sum of True/False (1/0)

Hi,

I am using this formula to search a multi-select column for if that column contains "IDS".

=IF(CONTAINS("IDS", [Define Resource Needs]@row:[Define Resource Needs]@row), "1", "0")

It is returning the 0 or 1 to me just fine - but what I want is a sum of the instances of "1". This will give me a count of how many times in that column "IDS" is labeled as "true" or "1".

However, the sum function both in the sheet itself and within the Summary function in the report is only giving me "0". What am I doing wrong?


Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!