hi; i want to get the specific value from ano...

(Selim Tuncay) #1

hi; i want to get the specific value from another table and i want use it in formula for show if … table#1 [Column1] lastRow

is it possible?

thank you

(Levent KULAÇOĞLU) #2

ANY(SELECT(Table[Column],MAX(Table[_ROWNUMBER])=[_ROWNUMBER]))

(Selim Tuncay) #3

thank you1

(Selim Tuncay) #4

(day(today()))<>(day(ANY(SELECT(Durum[DevirTarih],MAX(Durum[DevirTarih])=[1]))))

i did this. i tested it works.use it for show if formula for one

view but even condition result “False” still the view appears in menu.

(Praveen Seshadri (AppSheet)) #5

That formula is confusing to me

MAX(Durum[DevirTarih]) = [1]

— not sure what that is

(Selim Tuncay) #6

@praveen thanks Seshadri! that was exactly . i found it out. it works well