Skip to main content
Question

Need Formula to Count Amount of Items

  • November 16, 2022
  • 0 replies
  • 80 views
Forum|alt.badge.img+6
Good Afternoon All,

My company is conducting a baggage survey where we must record all types and weights of baggage during the operation.  My form is set up as items 1-20, as well as weights 1-20.  I had no problem creating a total weight field, but I need a formula field that counts the amount of items.  The item field has words instead of numbers (such as personal bag, checked bag, crew bag, etc.), so I need a formula that will count any of these as 1 and then total it up.

Appreciate any help you can offer!
Aidon

------------------------------
Aidon Olligschlager
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    Try this

    Count(
    [Bag Type 1] <> "",
    [Bag Type 2] <> "",
    etc
    [Bag Type 20] <> "")


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement