Formula for Levels

Support
1

I have a subtable that has items of yes or no. If all items are yes, then on another cell, I want it to show up as Yes. If one is missing or has a no, I want it to be say no. This would be in the Level 1 - Fundamentals area.

Screenshot 2025-03-04 at 4.41.07 PM
Screenshot 2025-03-04 at 4.41.07 PM2528×972 121 KB

2

Hi,

Here are three formula types you would have to use in your “Level 1 - Fundamentals” field.

  1. COUNT(): Count the number of subtable entries in a subtable.
  2. COUNTIF(): Count the number of subtable entries with the “Yes” value.
  3. Conditional IF(): Check if the values returned from the COUNT() formula and the COUNTIF() formula are equal. If they are equal, that means all subtable entries have the “Yes” value.