- Macam-macam dropdown di valid if
- Buat dropdown yang tergantung pada kolom sebelumnya
- IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region]
- CONCATENATE("IURAN BULAN ", TEXT(MONTH([TGL TERBIT])), " ( ",IFS(TEXT(MONTH([TGL TERBIT]))= "1", "JANUARI", TEXT(MONTH([TGL TERBIT]))= "2", "FEBRUARI", TEXT(MONTH([TGL TERBIT]))= "3", "MARET", TEXT(MONTH([TGL TERBIT]))= "4", "APRIL", TEXT(MONTH([TGL TERBIT]))= "5", "MEI", TEXT(MONTH([TGL TERBIT]))= "6", "JUNI", TEXT(MONTH([TGL TERBIT]))= "7", "JULI", TEXT(MONTH([TGL TERBIT]))= "8", "AGUSTUS", TEXT(MONTH([TGL TERBIT]))= "9", "SEPTEMBER", TEXT(MONTH([TGL TERBIT]))= "10", "OKTOBER", TEXT(MONTH([TGL TERBIT]))= "11", "NOVEMBER", TEXT(MONTH([TGL TERBIT]))= "12", "DESEMBER"), " ) ")
Friday, July 28, 2017
APPSHEET
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment