Valid if condition

AppSheet AppSheet Q&A
1

I’m trying to create a Valid If condition on a (text) field in Table A based on using a (date) field from Table B. The condition evaluates as true and it should not for every row in the small table B. My Valid If Is:

SELECT( Weeks[WeekRange], ANY(Weeks[WeekEnd]) < DATE(‘11/01/2024’))

Thoughts?

2

Hi @Rik_Rowe1

Can you try this:

SELECT(Weeks[WeekRange]
  [WeekEnd]<ANY(tableB[date])
)
3

Off course your suggestion worked! I appreciate you helping me get more sleep!!

1 Like