Expression Error

[Sirfyaad]

Don't know why the expression here is telling wrong. 

Error Message Showing:- 

The expression is valid but its result type 'List' is not one of the expected types: Yes/No

FILTER("Sameday photo", AND(ISNOTBLANK([Date]),[Date] >= TODAY()  ))

 

[James_McFarlane]

The expected result for a CONDITION is YES/NO or TRUE/FALSE the formula used is a FILTER which returns a list of values. Might be missing wrapping the FILTER with COUNT(FILTER..))>0

[Sirfyaad]

@James_McFarlane  @Thank you for your Response

Your suggestion is true but showing error

COUNT(

FILTER(
"SCAN SHEET",
AND(
ISNOTBLANK([Date]),
[Date] >= TODAY()
)
)
) > 0

 

 

[James_McFarlane]

This is a new error message related to how the bot is configured because it is based on 2 different tables.

[Sirfyaad]

How can I fix this error. 

[Sirfyaad]

Need help 

[jaichith]

Call a script. Or set the tables correctly

[Franco_Reyes]

Hola buenas tardes. 

Esa formula te devuelve la lista de id donde ese evento esta ocurriendo. Deberia ser un resultado verdadero o falso ejemplo prueba esta solucion 

Isnotblank(FILTER("Sameday photo", AND(ISNOTBLANK([Date]),[Date] >= TODAY() )))

Si hay al menos un id en la lista de filter será true y quizas ahi funcione el bot. Espero te sirva el ejemplo. Saludos.