bdbeer

Ok, great. Then it doesn’t place a heavy burden on my server hardware ??

Perhaps this dragon is something you can use to code the MIN function that ignores empty cells?

Hi,

Try this :’)

=MIN(IF(I2=0,MAX(I2:V2),I2),IF(J2=0,MAX(I2:V2),J2),IF(K2=0,MAX(I2:V2),K2),IF(L2=0,MAX(I2:V2),L2),IF(M2=0,MAX(I2:V2),M2),IF(N2=0,MAX(I2:V2),N2),IF(O2=0,MAX(I2:V2),O2),IF(P2=0,MAX(I2:V2),P2),IF(Q2=0,MAX(I2:V2),Q2),IF(R2=0,MAX(I2:V2),R2),IF(S2=0,MAX(I2:V2),S2),IF(T2=0,MAX(I2:V2),T2),IF(U2=0,MAX(I2:V2),U2),IF(V2=0,MAX(I2:V2),V2))

What it does is basically check if a cell value is 0 (empty) and if so, it returns the highest value of the same range. If not, it returns the cell value which is then inserted into a MIN function.

It’s a bit of a dragon, but it works.

Is this formula evaluated every time the table is requested on a page, or is it processed only when the table is saved?

Is it possible to add a function that only counts the value if x>0?

Addif
Countif

That sort of thing?

You’re not the only one who is getting this error. Did you find a way to take care of it yet?

I’m getting the same error and would like to get rid of it. But how?

For people that came to this link: Dutch translation will be added to the next release.

Thanks for your help! Much appreciated.

I was thinking about what I can do in return. There is no translation to the Dutch language yet, so perhaps I can help you with that?

if ( is_wp_error( $user ) )
$url = add_query_arg( ‘authentication’, ‘failed’, $url );
else
$url = add_query_arg( ‘authentication’, ‘success’, ‘https://mywebsite.here.com’ );

wp_safe_redirect( $url );

So like this?

How would I add a short delay in there? So users would see “authentication succeeded” for a couple of seconds?

Would this be the correct syntax?

if ( is_wp_error( $user ) )
$url = add_query_arg( ‘authentication’, ‘failed’, $url );
else
$url = add_query_arg( ‘authentication’, ‘success’, https://mywebsite.here.com );

wp_safe_redirect( $url );

If only I knew how to code (well), I would love to contribute.

Would it be possible to implement this as a feature that can be configured in the clean-login settings?
“After login, forward to page: xxx” after “yy” seconds.