SUM checkbox values

[undu82]

Hi, is it possible to sum the values of all the selected checkboxes? Based on what I have read, it supposes to be SUM({checkbox_field}), but it only gave me the first value.

Thanks!

[Doug_Den_Hoed__AtAppStore · Accepted solution]

Hi @undu82,

Working with multi-select checkboxes can be a bit tricky, but you could adapt the approach I outlined in this post (to fix the order of items) in order to sum up the selected values by following this pattern (using the same example, and valuing each entry at 1 if selected and 0 if not selected):

AtApp Swimlane Tag Summed:
SUM(
IF(CONTAINS("Swimlane Portfolio",{DE:AtApp Swimlane Tag}),1,0)
,IF(CONTAINS("Swimlane Program",{DE:AtApp Swimlane Tag}),1,0)
,IF(CONTAINS("Swimlane Project Owner",{DE:AtApp Swimlane Tag}),1,0)
,IF(CONTAINS("Swimlane Project",REPLACE({DE:AtApp Swimlane Tag},"Swimlane Project Owner","SwimlaneProjectOwner")),1,0)
)

In this fashion, you could also assign different weighted values for different entries (e.g. 5 for Portfolio, 4 for Program, etc.)

Regards,

Doug

[undu82]

Thank you very much @Doug_Den_Hoed__AtAppStore !