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?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!