Sum of True/False (1/0)

Emily Wildberger

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!

Paul Newcome

By wrapping your numbers in quotes, you are outputting text strings that just look like numbers. Try removing the quotes from around the one and the zero in your IF statement and see if that does the trick for you.

Paul Newcome

By wrapping your numbers in quotes, you are outputting text strings that just look like numbers. Try removing the quotes from around the one and the zero in your IF statement and see if that does the trick for you.

Emily Wildberger

Thank you so much! This is great!

Paul Newcome

Happy to help. 👍️