Sum of True/False (1/0)
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?
Help Article Resources
Check out the Formula Handbook template!