Welcome!

Formula to add multiple dropdown with a criteria

Example

Column 1

banana

orange

watermelon

Column 2

kid 1

kid 2

kid 3

I want to create an equation that counts, how many times kid 1 has chosen banana and orange???

Formulas

You would use something along the lines of...

=COUNTIFS([Column 2]:[Column 2], "kid 1", [Column 1]:[Column 1], AND(CONTAINS("banana", @cell), CONTAINS("orange", @cell)))

Counting value repeats since last distinct value
Hi Smartsheet experts! I'm trying to accomplish something like the above, where I count the number of repeats of one value in a column, but that count resets when the value changes and resets to 1 if the same name appears later. This is to consolidate an order form where users can order different numbers of items- it's…
Total Sum not calculating in Smartsheet correctly
Hello SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?…
Need help calculating hours allocated per week for team members
I need help creating a formula to calculate how many hours my team is allocated for per week. I have three columns in my sheet that we use for task management. Hrs per week - is a number on the hours it takes Assigned to - is a manual text field of the team member who is doing the task Due Date - when it is due (typically…