Discussions

 View Only
  • 1.  Formula Field - Sums Multiple Fields with Filtered Criteria

    Posted 11-30-2022 10:42
      |   view attached
    Hello All,

    I need a formula for a field that sums up the total weight of specific bags in my table.

    I currently have 25 Text-Multiple Choice fields titled "Item 1," "Item 2," etc., and 25 numeric fields titles "Weight 1," "Weight 2," etc.​  Each Item field has 4 choices.  One of which is "Checked Bag," and then the relevant weight is displayed in the corresponding weight field based by number. 

    I need a formula that sums up the total weight of all items (1-25), if the item field is equal to "Checked Bag."

    Hoping for a simple fix here.  Thanks,

    ------------------------------
    Aidon Olligschlager
    ------------------------------


  • 2.  RE: Formula Field - Sums Multiple Fields with Filtered Criteria

    Posted 11-30-2022 13:30
    To update, I have figured out how to pull the values I need and am testing it on the first couple entries.  However, I cannot figure out how to get the formula to add up all the values, rather than just display the values I'd like to pull.  See attached photos for reference.

    ------------------------------
    Aidon Olligschlager
    ------------------------------



  • 3.  RE: Formula Field - Sums Multiple Fields with Filtered Criteria

    Posted 11-30-2022 16:38
      |   view attached
    To conclude, I did end up figuring out a solution:

    First step was to use a Numeric Formula field instead of a Text Formula.  I attached the solution in the file section.

    Thanks!

    ------------------------------
    Aidon Olligschlager
    ------------------------------