Solved
SUM checkbox values
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_AtAppStoreAccepted solution
Community Advisor
Mar 9, 2023 11:38 PM UTC
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
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.