{"id":18556,"date":"2024-04-26T11:32:29","date_gmt":"2024-04-26T04:32:29","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=18556"},"modified":"2024-05-30T15:25:54","modified_gmt":"2024-05-30T08:25:54","slug":"xay-dung-cong-thuc-trong-appsheet","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/","title":{"rendered":"X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c trong Appsheet"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element\" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<p><span style=\"font-weight: 400;\">Vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong AppSheet l\u00e0 m\u1ed9t kh\u00eda c\u1ea1nh quan tr\u1ecdng c\u1ee7a vi\u1ec7c x\u00e2y d\u1ef1ng \u1ee9ng d\u1ee5ng di \u0111\u1ed9ng m\u00e0 kh\u00f4ng \u0111\u00f2i h\u1ecfi k\u1ef9 n\u0103ng l\u1eadp tr\u00ecnh chuy\u00ean s\u00e2u. C\u00f4ng th\u1ee9c gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1eadn d\u1ee5ng d\u1eef li\u1ec7u c\u00f3 s\u1eb5n v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n, ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n, v\u00e0 t\u1ed5 ch\u1ee9c th\u00f4ng tin m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng. AppSheet cung c\u1ea5p m\u1ed9t lo\u1ea1t c\u00e1c h\u00e0m t\u00ednh to\u00e1n, t\u1eeb nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u01b0 SUM v\u00e0 AVG \u0111\u1ebfn nh\u1eefng h\u00e0m ph\u1ee9c t\u1ea1p nh\u01b0 LOOKUP v\u00e0 IF. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng t\u1ea1o ra c\u00e1c c\u00f4ng th\u1ee9c linh ho\u1ea1t \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u00f4ng tin, t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb m\u1edbi, v\u00e0 t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Tong_quan_ve_cong_thuc\" >T\u1ed5ng quan v\u1ec1 c\u00f4ng th\u1ee9c\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Tong_quan_ve_xay_dung_cong_thuc\" >T\u1ed5ng quan v\u1ec1 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c\u00a0<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Cac_luu_y_khi_xay_dung_cong_thuc_trong_AppSheet\" >C\u00e1c l\u01b0u \u00fd khi x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c trong AppSheet\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Cach_xay_dung_cong_thuc_trong_AppSheet\" >C\u00e1ch x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c trong AppSheet\u00a0<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Truy_cap_Expression_Assistant\" >Truy c\u1eadp Expression Assistant<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Xay_dung_cong_thuc\" >X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Xem_va_chen_tham_chieu_cot_vao_cac_cong_thuc\" >Xem v\u00e0 ch\u00e8n tham chi\u1ebfu c\u1ed9t v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Xem_va_chen_cac_mau_duoc_xac_dinh_truoc_vao_cac_cong_thuc\" >Xem v\u00e0 ch\u00e8n c\u00e1c m\u1eabu \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/#Ket_luan\" >Conclusion\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tong_quan_ve_cong_thuc\"><\/span><b>T\u1ed5ng quan v\u1ec1 c\u00f4ng th\u1ee9c\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00f3 r\u1ea5t nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p khi s\u1eed d\u1ee5ng \u1ee9ng d\u1ee5ng AppSheet m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c bi\u1ec3u th\u1ee9c \u0111\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn h\u00e0nh vi c\u1ee7a \u1ee9ng d\u1ee5ng v\u00e0 cung c\u1ea5p ch\u1ee9c n\u0103ng cao c\u1ea5p cho ng\u01b0\u1eddi d\u00f9ng. M\u1ed9t s\u1ed1 t\u00ednh n\u0103ng c\u1ee7a AppSheet s\u1eed d\u1ee5ng bi\u1ec3u th\u1ee9c bao g\u1ed3m: c\u00f4ng th\u1ee9c \u1ee9ng d\u1ee5ng, gi\u00e1 tr\u1ecb kh\u1edfi t\u1ea1o, r\u00e0ng bu\u1ed9c c\u1ed9t, c\u1ed9t \u1ea3o,&#8230;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">AppSheet ki\u1ec3m tra t\u1ea5t c\u1ea3 c\u00e1c bi\u1ec3u th\u1ee9c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ch\u00fang \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch th\u00edch h\u1ee3p. V\u00ed d\u1ee5, n\u1ebfu m\u1ed9t bi\u1ec3u th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 g\u00e1n gi\u00e1 tr\u1ecb kh\u1edfi t\u1ea1o cho m\u1ed9t c\u1ed9t ki\u1ec3u \u201cS\u1ed1\u201d, AppSheet s\u1ebd ki\u1ec3m tra xem k\u1ebft qu\u1ea3 c\u1ee7a bi\u1ec3u th\u1ee9c c\u00f3 th\u1ef1c s\u1ef1 l\u00e0 m\u1ed9t \u201cS\u1ed1\u201d hay kh\u00f4ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: N\u1ebfu b\u1ea1n quen thu\u1ed9c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c b\u1ea3ng t\u00ednh trong Microsoft Excel ho\u1eb7c Google Sheets, b\u1ea1n s\u1ebd th\u1ea5y bi\u1ec3u th\u1ee9c c\u1ee7a AppSheet t\u01b0\u01a1ng t\u1ef1 v\u1ec1 c\u00fa ph\u00e1p v\u00e0 \u00fd ngh\u0129a. M\u1ed9t bi\u1ec3u th\u1ee9c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng v\u1edbi b\u1ea5t k\u1ef3 s\u1ef1 k\u1ebft h\u1ee3p n\u00e0o c\u1ee7a c\u00e1c th\u00e0nh ph\u1ea7n sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u1eb1ng s\u1ed1\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1ed1: b\u1ea5t k\u1ef3 s\u1ed1 nguy\u00ean t\u1ed1 n\u00e0o, d\u01b0\u01a1ng ho\u1eb7c \u00e2m.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ng\u00e0y v\u00e0 gi\u1edd, \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p. \u0110\u1ecbnh d\u1ea1ng ng\u00e0y l\u00e0 MM\/DD\/YYYY v\u00e0 gi\u1edd l\u00e0 HH:MM:SS. V\u00ed d\u1ee5, &#8220;12\/31\/1999&#8221; v\u00e0 &#8220;10:15:00&#8221;.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V\u0103n b\u1ea3n, \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p. V\u00ed d\u1ee5, &#8220;T\u1eeb kh\u00f3a&#8221;.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Pillar\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u1eed d\u1ee5ng gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t c\u1ed9t b\u1eb1ng c\u00e1ch \u0111\u1eb7t t\u00ean c\u1ed9t trong d\u1ea5u ngo\u1eb7c vu\u00f4ng nh\u01b0 sau: [Column]. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u1ed9t trong c\u00e1c bi\u1ec3u th\u1ee9c.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dereferences (Gi\u1ea3i tham chi\u1ebfu) l\u00e0 m\u1ed9t lo\u1ea1i bi\u1ec3u th\u1ee9c h\u1eefu \u00edch khi c\u00f3 tham chi\u1ebfu gi\u1eefa c\u00e1c b\u1ea3ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00e1c c\u1ed9t t\u1eeb c\u00e1c b\u1ea3ng kh\u00e1c trong \u1ee9ng d\u1ee5ng m\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i b\u1eb1ng tham chi\u1ebfu, ch\u1ec9 \u0111\u1ecbnh t\u00ean b\u1ea3ng v\u00e0 gi\u00e1 tr\u1ecb c\u1ed9t b\u1eb1ng c\u00fa ph\u00e1p sau: Table[Column].<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tong_quan_ve_xay_dung_cong_thuc\"><\/span><b>T\u1ed5ng quan v\u1ec1 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong AppSheet, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u00ednh to\u00e1n d\u1eef li\u1ec7u \u0111\u1ed9ng: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh to\u00e1n tr\u00ean d\u1eef li\u1ec7u theo th\u1eddi gian, gi\u00fap c\u1eadp nh\u1eadt th\u00f4ng tin li\u00ean t\u1ee5c v\u00e0 \u0111\u00e1p \u1ee9ng c\u00e1c y\u00eau c\u1ea7u thay \u0111\u1ed5i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n: S\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u0111i\u1ec1u ki\u1ec7n nh\u01b0 IF \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh h\u00e0nh \u0111\u1ed9ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c tr\u01b0\u1eddng d\u1eef li\u1ec7u.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ed1i \u01b0u h\u00f3a hi\u1ec3n th\u1ecb th\u00f4ng tin: \u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng tin m\u1ed9t c\u00e1ch tr\u1ef1c quan, gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng theo d\u00f5i v\u00e0 hi\u1ec3u th\u00f4ng tin.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh c\u00f4ng vi\u1ec7c: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c b\u01b0\u1edbc trong quy tr\u00ecnh l\u00e0m vi\u1ec7c, t\u1eeb t\u00ednh to\u00e1n \u0111\u1ebfn g\u1eedi th\u00f4ng b\u00e1o.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u1edbi kh\u1ea3 n\u0103ng linh ho\u1ea1t c\u1ee7a c\u00f4ng th\u1ee9c trong AppSheet, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c \u1ee9ng d\u1ee5ng di \u0111\u1ed9ng th\u00f4ng minh v\u00e0 \u0111\u00e1p \u1ee9ng linh ho\u1ea1t v\u1edbi nhu c\u1ea7u kinh doanh v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac_luu_y_khi_xay_dung_cong_thuc_trong_AppSheet\"><\/span><b>C\u00e1c l\u01b0u \u00fd khi x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c trong AppSheet\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c trong AppSheet, c\u00f3 m\u1ed9t s\u1ed1 \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c:\u00a0<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">\u0110\u1ecbnh r\u00f5 m\u1ee5c ti\u00eau: X\u00e1c \u0111\u1ecbnh r\u00f5 m\u1ee5c ti\u00eau c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u1ec3 c\u00f3 chi\u1ebfn l\u01b0\u1ee3c ph\u00e1t tri\u1ec3n h\u1ee3p l\u00fd.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ki\u1ec3m tra d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o: \u0110\u1ea3m b\u1ea3o r\u1eb1ng d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o cho c\u00f4ng th\u1ee9c l\u00e0 ch\u00ednh x\u00e1c v\u00e0 \u0111\u1ea7y \u0111\u1ee7.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Hi\u1ec3u c\u00fa ph\u00e1p c\u00f4ng th\u1ee9c: AppSheet s\u1eed d\u1ee5ng c\u00fa ph\u00e1p c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1c h\u1ec7 th\u1ed1ng b\u1ea3ng t\u00ednh. Hi\u1ec3u r\u00f5 c\u00fa ph\u00e1p s\u1ebd gi\u00fap b\u1ea1n t\u1eadn d\u1ee5ng \u0111\u01b0\u1ee3c \u0111\u1ea7y \u0111\u1ee7 t\u00ednh n\u0103ng c\u1ee7a n\u1ec1n t\u1ea3ng.\u00a0<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_xay_dung_cong_thuc_trong_AppSheet\"><\/span><b>C\u00e1ch x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c trong AppSheet\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc ti\u1ebfp theo sau khi \u0111\u00e3 l\u01b0u \u00fd \u0111\u1ebfn c\u00e1c \u0111i\u1ec3m quan tr\u1ecdng l\u00e0 x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc c\u01a1 b\u1ea3n:\u00a0<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Truy_cap_Expression_Assistant\"><\/span><b>Truy c\u1eadp Expression Assistant<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Trong tr\u00ecnh ch\u1ec9nh s\u1eeda \u1ee9ng d\u1ee5ng, b\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp Expression Assistant &#8211; n\u01a1i m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c. C\u00e1c b\u1ea1n l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng l\u1ecd thu\u1ef7 tinh b\u00ean c\u1ea1nh tr\u01b0\u1eddng nh\u1eadp \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i sang \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u th\u1ee9c (n\u1ebfu c\u00f3 s\u1eb5n). V\u00ed d\u1ee5:<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18569 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet.jpg\" alt=\"\" width=\"319\" height=\"113\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet.jpg 319w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-18x6.jpg 18w\" sizes=\"auto, (max-width: 319px) 100vw, 319px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nh\u1ea5p v\u00e0o tr\u01b0\u1eddng bi\u1ec3u th\u1ee9c \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh b\u1eb1ng d\u1ea5u b\u1eb1ng (=). V\u00ed d\u1ee5:<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/xay-dung-cong-thuc-trong-appsheet\/attachment\/cong-thuc-appsheet-1\/\" rel=\"attachment wp-att-18568\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18568\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-1.jpg\" alt=\"\" width=\"300\" height=\"138\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-1.jpg 300w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-1-18x8.jpg 18w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: D\u1ea5u b\u1eb1ng ch\u1ec9 ra r\u1eb1ng k\u1ebft qu\u1ea3 c\u1ee7a bi\u1ec3u th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0m gi\u00e1 tr\u1ecb c\u1ee7a c\u00e0i \u0111\u1eb7t.<\/span><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Xay_dung_cong_thuc\"><\/span><b>X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400;\">X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Expression Assistant nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18567 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-2.jpg\" alt=\"\" width=\"601\" height=\"367\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-2.jpg 601w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-2-18x12.jpg 18w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>Nh\u01b0 \u0111\u01b0\u1ee3c l\u00e0m n\u1ed5i b\u1eadt trong h\u00ecnh tr\u01b0\u1edbc \u0111\u00f3, Expression Assistant cho ph\u00e9p b\u1ea1n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">X\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n trong v\u00f9ng v\u0103n b\u1ea3n<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">X\u00e1c nh\u1eadn c\u00fa ph\u00e1p h\u1ee3p l\u1ec7 v\u00e0 ch\u1ee9c n\u0103ng c\u1ee7a c\u00f4ng th\u1ee9c<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Xem v\u00e0 ch\u00e8n tham chi\u1ebfu c\u1ed9t ho\u1eb7c m\u1eabu \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0o c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c tab \u1edf d\u01b0\u1edbi c\u1ee7a h\u1ed9p tho\u1ea1i<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ki\u1ec3m tra c\u00f4ng th\u1ee9c<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">M\u1edf r\u1ed9ng v\u00f9ng v\u0103n b\u1ea3n b\u1eb1ng c\u00e1ch:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">K\u00e9o thanh \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n, k\u00e9o d\u00e0i qua nhi\u1ec1u d\u00f2ng<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Thu g\u1ecdn c\u00e1c tab \u1edf d\u01b0\u1edbi c\u1ee7a h\u1ed9p tho\u1ea1i<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u01b0u c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o L\u01b0u ho\u1eb7c s\u1eed d\u1ee5ng Ctrl-Shift-S tr\u00ean PC ho\u1eb7c \u2318-Shift-S tr\u00ean Mac<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u1edbi c\u00e1c c\u1ea3i ti\u1ebfn c\u1ee7a Expression Assistant \u0111\u01b0\u1ee3c b\u1eadt, b\u1ea1n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng c\u00e1c t\u00ednh n\u0103ng sau \u0111\u1ec3 h\u1ed7 tr\u1ee3 b\u1ea1n v\u1edbi c\u00fa ph\u00e1p h\u00e0m c\u1ee7a AppSheet:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u00f4 s\u00e1ng c\u00fa ph\u00e1p \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a bi\u1ec3u th\u1ee9c b\u1eb1ng m\u00e0u s\u1eafc kh\u00e1c nhau<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18566 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-3.jpg\" alt=\"\" width=\"300\" height=\"29\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-3.jpg 300w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-3-18x2.jpg 18w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd m\u00e0u:<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">M\u00e0u xanh l\u00e1 c\u00e2y: C\u00e1c h\u00e0m c\u1ee7a AppSheet<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">M\u00e0u h\u1ed3ng: Tham chi\u1ebfu d\u1eef li\u1ec7u, ch\u1eb3ng h\u1ea1n nh\u01b0 t\u00ean c\u1ed9t<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">M\u00e0u xanh d\u01b0\u01a1ng: V\u0103n b\u1ea3n<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">M\u00e0u cam: S\u1ed1<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m hi\u1ec7n t\u1ea1i v\u1edbi t\u00f4 s\u00e1ng theo ng\u1eef c\u1ea3nh<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18565 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-4.jpg\" alt=\"\" width=\"400\" height=\"63\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-4.jpg 400w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-4-391x63.jpg 391w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-4-18x3.jpg 18w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">T\u1ef1 \u0111\u1ed9ng ho\u00e0n thi\u1ec7n cho c\u00e1c c\u1ed9t (khi con tr\u1ecf \u0111\u01b0\u1ee3c \u0111\u1eb7t trong c\u00f4ng th\u1ee9c ho\u1eb7c \u0111\u1ecbnh ngh\u0129a c\u1ed9t)<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">L\u01b0u \u00fd: B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + Space \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c g\u1ee3i \u00fd ho\u00e0n thi\u1ec7n t\u1ef1 \u0111\u1ed9ng.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18564 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-5.jpg\" alt=\"\" width=\"400\" height=\"102\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-5.jpg 400w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-5-18x5.jpg 18w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">B\u1ea3ng t\u00e0i li\u1ec7u cho vi\u1ec7c truy c\u1eadp nhanh ch\u00f3ng \u0111\u1ebfn m\u00f4 t\u1ea3 v\u00e0 c\u00fa ph\u00e1p cho h\u00e0m hi\u1ec7n t\u1ea1i<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18563 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-6.jpg\" alt=\"\" width=\"400\" height=\"289\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-6.jpg 400w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-6-18x12.jpg 18w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Xem_va_chen_tham_chieu_cot_vao_cac_cong_thuc\"><\/span><b>Xem v\u00e0 ch\u00e8n tham chi\u1ebfu c\u1ed9t v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Xem v\u00e0 ch\u00e8n tham chi\u1ebfu c\u1ed9t v\u00e0o c\u00e1c bi\u1ec3u th\u1ee9c b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o tab Data Explorer, nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18562 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-7.jpg\" alt=\"\" width=\"601\" height=\"568\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-7.jpg 601w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-7-13x12.jpg 13w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Tab Data Explorer cho ph\u00e9p b\u1ea1n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Xem t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng v\u00e0 c\u1ed9t trong \u1ee9ng d\u1ee5ng c\u1ee7a b\u1ea1n<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ch\u00e8n tham chi\u1ebfu c\u1ed9t v\u00e0o m\u1ed9t c\u00f4ng th\u1ee9c, nh\u01b0 m\u00f4 t\u1ea3 b\u00ean d\u01b0\u1edbi<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Xem c\u00e1c li\u00ean k\u1ebft Ref (tham chi\u1ebfu \u0111\u1ebfn c\u00e1c b\u1ea3ng kh\u00e1c)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">M\u1edf r\u1ed9ng v\u00e0 thu g\u1ecdn b\u1ea3ng, v\u00e0 ghim hi\u1ec3n th\u1ecb c\u1ee7a h\u1ecd trong Expression Assistant<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 ch\u00e8n m\u1ed9t tham chi\u1ebfu c\u1ed9t v\u00e0o m\u1ed9t c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nh\u1ea5p v\u00e0o v\u00f9ng v\u0103n b\u1ea3n c\u00f4ng th\u1ee9c n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n tham chi\u1ebfu c\u1ed9t.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">M\u1edf r\u1ed9ng b\u1ea3ng ch\u1ee9a c\u1ed9t b\u1ea1n mu\u1ed1n th\u00eam.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1eb7t con tr\u1ecf c\u1ee7a b\u1ea1n qua t\u00ean c\u1ed9t v\u00e0 nh\u1ea5p v\u00e0o Insert.<\/span><\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"Xem_va_chen_cac_mau_duoc_xac_dinh_truoc_vao_cac_cong_thuc\"><\/span><b>Xem v\u00e0 ch\u00e8n c\u00e1c m\u1eabu \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c<\/b><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Xem v\u00e0 ch\u00e8n c\u00e1c m\u1eabu \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0o c\u00e1c c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o tab Examples, nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18561 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-8.jpg\" alt=\"\" width=\"599\" height=\"273\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-8.jpg 599w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-8-18x8.jpg 18w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Tab Examples cho ph\u00e9p b\u1ea1n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ch\u1ecdn lo\u1ea1i c\u00f4ng th\u1ee9c<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ch\u00e8n m\u1ed9t m\u1eabu \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0o m\u1ed9t c\u00f4ng th\u1ee9c, nh\u01b0 m\u00f4 t\u1ea3 b\u00ean d\u01b0\u1edbi<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 ch\u00e8n m\u1ed9t m\u1eabu \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0o m\u1ed9t c\u00f4ng th\u1ee9c:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nh\u1ea5p v\u00e0o v\u00f9ng v\u0103n b\u1ea3n c\u00f4ng th\u1ee9c n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n m\u1eabu v\u00ed d\u1ee5.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ch\u1ecdn tab d\u1ef1a tr\u00ean lo\u1ea1i c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n th\u00eam.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u0110\u1eb7t con tr\u1ecf c\u1ee7a b\u1ea1n qua m\u1eabu v\u00ed d\u1ee5 v\u00e0 nh\u1ea5p v\u00e0o Insert.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ki\u1ec3m tra c\u00f4ng th\u1ee9c<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c cho m\u1ed7i h\u00e0ng trong b\u1ea3ng, nh\u1ea5p v\u00e0o Test trong Expression Assistant. Trang Expression Test sex hi\u1ec3n th\u1ecb.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u1ed9t \u0111\u1ea7u ti\u00ean hi\u1ec3n th\u1ecb K\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c cho m\u1ed7i h\u00e0ng trong b\u1ea3ng, nh\u01b0 \u0111\u01b0\u1ee3c minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18559 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-9.jpg\" alt=\"\" width=\"500\" height=\"203\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-9.jpg 500w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-9-18x7.jpg 18w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/>M\u1edf r\u1ed9ng K\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u1edf r\u1ed9ng \u0111\u1ec3 xem k\u1ebft qu\u1ea3 c\u1ee7a m\u1ed7i ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18558 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-10.jpg\" alt=\"\" width=\"500\" height=\"216\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-10.jpg 500w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2024\/04\/cong-thuc-appsheet-10-18x8.jpg 18w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span><b>Conclusion\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1edbi kh\u1ea3 n\u0103ng t\u1ea1o ra c\u00f4ng th\u1ee9c m\u1ed9t c\u00e1ch linh ho\u1ea1t, AppSheet l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd cho vi\u1ec7c x\u00e2y d\u1ef1ng \u1ee9ng d\u1ee5ng di \u0111\u1ed9ng th\u00f4ng minh. Vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1ch x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c v\u00e0 l\u01b0u \u00fd \u0111\u1ebfn c\u00e1c \u0111i\u1ec3m quan tr\u1ecdng s\u1ebd gi\u00fap b\u1ea1n t\u1eadn d\u1ee5ng t\u1ed1i \u0111a ti\u1ec1m n\u0103ng c\u1ee7a n\u1ec1n t\u1ea3ng n\u00e0y \u0111\u1ec3 t\u1ea1o ra c\u00e1c \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 v\u00e0 linh ho\u1ea1t.<\/span><\/p>\n\n\t\t<\/div>\n\t<\/div>\n<div class=\"templatera_shortcode\"><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"vc_message_box vc_message_box-standard vc_message_box-rounded vc_color-blue\" ><div class=\"vc_message_box-icon\"><i class=\"vc-mono vc-mono-technorati\"><\/i><\/div><p><a href=\"https:\/\/gcloudvn.com\/en\/main-logo-1\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-664\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1.png\" alt=\"\" width=\"221\" height=\"72\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1.png 214w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1-18x6.png 18w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2021\/06\/main-logo-1-183x60.png 183w\" sizes=\"auto, (max-width: 221px) 100vw, 221px\" \/><\/a>As a senior partner of Google in Vietnam, Gimasys has more than 10+ years of experience, consulting on implementing digital transformation for 2000+ domestic corporations. Some typical customers Jetstar, Dien Quan Media, Heineken, Jollibee, Vietnam Airline, HSC, SSI...<\/p>\n<p>Gimasys is currently a strategic partner of many major technology companies in the world such as Salesforce, Oracle Netsuite, Tableau, Mulesoft.<\/p>\n<p>Contact Gimasys - Google Cloud Premier Partner for advice on strategic solutions suitable to the specific needs of your business:<\/p>\n<ul>\n<li>Email: gcp@gimasys.com<\/li>\n<li>Hotline: 0974 417 099<\/li>\n<\/ul>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\n<\/section>","protected":false},"excerpt":{"rendered":"Vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c trong AppSheet l\u00e0 m\u1ed9t kh\u00eda c\u1ea1nh quan tr\u1ecdng c\u1ee7a vi\u1ec7c x\u00e2y d\u1ef1ng \u1ee9ng d\u1ee5ng di \u0111\u1ed9ng m\u00e0 kh\u00f4ng \u0111\u00f2i h\u1ecfi k\u1ef9 n\u0103ng l\u1eadp tr\u00ecnh chuy\u00ean s\u00e2u. C\u00f4ng th\u1ee9c gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1eadn d\u1ee5ng d\u1eef li\u1ec7u&hellip;","protected":false},"author":2,"featured_media":18557,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-18556","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/18556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=18556"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/18556\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/18557"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=18556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=18556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=18556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}