SUM checkbox values | Community
Skip to main content
undu82
undu82
Level 2
March 9, 2023
Solved

SUM checkbox values

  • March 9, 2023
  • 1 reply
  • 718 views

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!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Doug_Den_Hoed_AtAppStore

     

    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

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
    Community Advisor
    March 9, 2023

     

    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
      undu82Author
      Level 2
      March 9, 2023

      Thank you very much @doug_den_hoed__atappstore !

        Terms & ConditionsAccessibility statement

        Loading footer...