Any workarounds for COUNTBLANK()?

[Jon_S]

Hey everyone!

I would like to track the progress on the completion of a given entry’s fields - tracking if they are blank or not… Maybe in a VC. So it would look something like COUNTBLANK([_THISROW])

So if say my form has 10 questions and the user has so far submitted 1/10 - the result of would read ‘9’.

OBVIOUSLY i can use that expression in GSheets and be done with it - but i’m just curious about whether or not this could be possible using an Appsheet expression instead of relying on a spreadsheet formula.

I’m pretty sure i’m just being a bit thick here I’m sure someone has bumped into this one before.

Many thanks in advance!