Substitute formula for an email condition

[Nani]

I have a table where it contains 50 columns and all these columns are questions and they enter the answers in the text format. Now, what I want is I need to get email if they fill aleast 25 columns. So, in the bots -> Event -> Condition, I will use this formula 

COUNT(
SELECT(
TableName[Question1],
AND(ISNOTBLANK([Question1]), ISNOTBLANK([Question2]), ..., ISNOTBLANK([Question50]))
)
) >= 25

However, I wanted to know, is there another formula similar to this, because all the questions I am having or of 3 to 5 lines, and it will be hard for me to enter all the 50 questions in the formula

[Marc_Dillon]

No, it won't be easy for such a setup. I'd suggest counting the number of answers with a formula like this:

IFS( ISNOTBLANK([col1]) , 1 )
+ IFS( ISNOTBLANK([col2]) , 1 )
+ IFS( ISNOTBLANK([col3]) , 1 )
....

[Nani]

Something like this, right?

IFS( ISNOTBLANK([col1]), 1,
        ISNOTBLANK([col2]), 1,
        ISNOTBLANK([col3]), 1,
        ISNOTBLANK([col4]), 1,
........) >=25

[Marc_Dillon]

Yes and no. Yes to the compare against 25 part, but you need the IFS for each column. You're basically tallying them up.

[Nani]

So this would be the final answer

IFS( ISNOTBLANK([col1]) , 1 )
+ IFS( ISNOTBLANK([col2]) , 1 )
+ IFS( ISNOTBLANK([col3]) , 1 )
.... >=25

If not please help me with the final answer