I have 2 tables ([Table1] and [Table2]). And I need to make a condition for bot event for table 1, provided that if in table 2 in the [Date] column in the last row [Date]=TODAY() and in the Table 1 in the column [ID]="123", then the condition is valid. Help me with syntax.
Solved! Go to Solution.
It should be something like.. AND(LOOKUP(MAXROW("Table2","_ROWNUMBER"),Table2,Key,Date)=TODAY(),[ID]="123")
It should be something like.. AND(LOOKUP(MAXROW("Table2","_ROWNUMBER"),Table2,Key,Date)=TODAY(),[ID]="123")
What is Key?
It's your own key column's name in Table2
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |