Hello Experts
I have below columns which takes input value 1, ,2 3, 4, 5, NA
What I'm trying is to have count virtual column of all columns which value is not equal to "NA"
the result should show in virtual column in real time.
Below is the formula which is accepted but its not excluding column(s) in count which has value "NA"
COUNT(
LIST(
IF([Activity-01] <> "NA", 1, ""),
IF([Activity-02] <> "NA", 1, ""),
IF([Activity-03] <> "NA", 1, ""),
IF([Activity-04] <> "NA", 1, ""),
IF([Activity-05] <> "NA", 1, "")
)
)
Please advise what is wrong with this
P.S. I have tried looking into appsheet training guide but I couldn't not find issue or solution
LinkedIn
Twitter
