I really don’t know how to ask for what I want. This might already be covered, but this mommy-brain newbie just doesn’t know the correct terminology to ask.
I want to count a list of lines in a table that have x and y. Then, record that number in a certain place on another table. I want it to auto-update based on me changing x or y to a or b… for example.
Clear as mud?
Add a column to the table with items that you want to count.
Use the following formula (and adjust {Field Name}, “x” and “y” to your parameters)
IF(AND(FIND("x", {Field Name}) > 0, FIND("y", {Field Name}) > 0), 1, 0)
Then on your other table, add a Rollup field that looks at this field and sums the values.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.