How to count populated fields in forms

AppSheet AppSheet Q&A
,
1

I need an expression that results in the sum of all the populated fields of a form, as if each of the fields added +1.
For example, if I have a form with 7 fields, and only 5 are populated, the result of the expression is number “5”.
It would also be interesting how I can express this formula in percentages.

Thanks!

2

Something like this?

(
  0
  + IFS(ISNOTBLANK([column1]), 1),
  + IFS(ISNOTBLANK([column2]), 1),
  ...
  + IFS(ISNOTBLANK([columnN]), 1)
)
1 Like
3

Gracias Steve! Eso funcionó!

I share how is the formula to calculate the percentage.

(
(
   0
   + IFS (ISNOTBLANK ([name]), 0.1),
   + IFS (ISNOTBLANK ([type]), 0.1),
   + IFS (ISNOTBLANK ([description]), 0.1),
   + IFS (ISNOTBLANK ([identifier]), 0.1),
   + IFS (ISNOTBLANK ([unit_measure]), 0.1),
   + IFS (ISNOTBLANK ([special_type]), 0.1),
   + IFS (ISNOTBLANK ([special_type_detail]), 0.1)
)
* 1)
/ 0.7

QUOTE: “Percent is a Decimal with special display characteristics. For example, a Percent value of 0.0 is displayed as 0%; 0.05 is displayed as 5%; 0.2 as 20%; and 1.0 as 100%.”

3 Likes