{"id":36926,"date":"2024-08-04T14:00:00","date_gmt":"2024-08-04T07:00:00","guid":{"rendered":"https:\/\/adsplus.vn\/blog\/?p=36926"},"modified":"2024-07-29T16:53:31","modified_gmt":"2024-07-29T09:53:31","slug":"cach-tao-data-validation-trong-google-sheet","status":"publish","type":"post","link":"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet","title":{"rendered":"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet"},"content":{"rendered":"\n<p><b>C\u00e1ch t\u1ea1o Data Validation trong Google Sheet <\/b><span style=\"font-weight: 400;\">l\u00e0 k\u1ef9 n\u0103ng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng nhi\u1ec1u trong c\u00f4ng vi\u1ec7<\/span>c <span style=\"font-weight: 400;\">th\u01b0\u1eddng ng\u00e0y. T\u00ednh n\u0103ng n\u00e0y h\u1ed7 tr\u1ee3 s\u1eafp x\u1ebfp, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft \u1ee9ng d\u1ee5ng Data Validation trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0o, h\u00e3y xem ngay th\u00f4ng tin trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb-1.png\" alt=\"C\u00e1ch t\u1ea1o Data Validation trong Google Sheet h\u1ed7 tr\u1ee3 qu\u1ea3n l\u00fd v\u00e0 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n.\" class=\"wp-image-36936\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb-1.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb-1-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb-1-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb-1-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb-1-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h4 class=\"wp-block-heading\"><b>Xem th\u00eam:<\/b><\/h4>\n\n\n\n<ul>\n<li><a href=\"https:\/\/adsplus.vn\/blog\/free-template-mau-quan-ly-thong-tin-khach-hang-cho-startup\"><span style=\"font-weight: 400;\">[FREE TEMPLATE] Sheet qu\u1ea3n l\u00fd th\u00f4ng tin kh\u00e1ch h\u00e0ng cho Startup<\/span><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ai-tool-cho-google-sheet\"><span style=\"font-weight: 400;\">T\u1ed5ng h\u1ee3p c\u00e1c AI tool cho Google Sheet<\/span><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/adsplus.vn\/blog\/lam-the-nao-de-su-dung-chat-gpt-trong-microsoft-excel\"><span style=\"font-weight: 400;\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng Chat GPT trong Microsoft Excel?<\/span><\/a><span style=\"font-weight: 400;\">&nbsp;<\/span><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><b>V\u00ec sao c\u1ea7n bi\u1ebft c\u00e1ch t\u1ea1o Data Validation trong Google Sheet?<\/b><\/h2>\n\n\n\n<p><span style=\"font-weight: 400;\">Data Validation l\u00e0 m\u1ed9t t\u00ednh n\u0103ng cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng thi\u1ebft l\u1eadp c\u00e1c quy t\u1eafc nh\u1eadp li\u1ec7u cho b\u1ea3ng t\u00ednh. C\u00e1ch t\u1ea1o Data Validation trong Google Sheet s\u1ebd ch\u1ec9 nh\u1eadn nh\u1eefng gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 theo quy t\u1eafc \u0111\u00e3 \u0111\u1ecbnh tr\u01b0\u1edbc. \u0110i\u1ec1u n\u00e0y mang l\u1ea1i nhi\u1ec1u l\u1ee3i \u00edch \u0111\u00e1ng k\u1ec3 trong qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc h\u1ebft, n\u00f3 gi\u00fap gi\u1ea3m thi\u1ec3u l\u1ed7i nh\u1eadp li\u1ec7u, m\u1ed9t v\u1ea5n \u0111\u1ec1 ph\u1ed5 bi\u1ebfn khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn. Data Validation s\u1ebd h\u1ea1n ch\u1ebf nh\u1eefng gi\u00e1 tr\u1ecb c\u00f3 th\u1ec3 nh\u1eadp v\u00e0o. T\u1eeb \u0111\u00f3, c\u00f3 th\u1ec3 \u0111\u1ea3m b\u1ea3o cho b\u1ea3ng t\u00ednh ch\u1ec9 xu\u1ea5t hi\u1ec7n d\u1eef li\u1ec7u h\u1ee3p l\u1ec7.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">Data Validation c\u00f2n gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c trong vi\u1ec7c ki\u1ec3m tra v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u. Thay v\u00ec ph\u1ea3i d\u00e0nh h\u00e0ng gi\u1edd \u0111\u1ec3 t\u00ecm v\u00e0 s\u1eeda l\u1ed7i d\u1eef li\u1ec7u, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp c\u00e1c quy t\u1eafc t\u1eeb \u0111\u1ea7u \u0111\u1ec3 ng\u0103n ch\u1eb7n l\u1ed7i. Nh\u1edd \u0111\u00f3, quy tr\u00ecnh qu\u1ea3n l\u00fd d\u1eef li\u1ec7u <\/span>tr\u1edf n\u00ean <span style=\"font-weight: 400;\">hi\u1ec7u qu\u1ea3 h\u01a1n.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><b>C\u00e1ch t\u1ea1o Data Validation trong Google Sheet chi ti\u1ebft<\/b><\/h2>\n\n\n\n<p><span style=\"font-weight: 400;\">Trong th\u1ef1c t\u1ebf, t\u00ednh n\u0103ng Data Validation th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng \u0111\u1ec3 gi\u1ea3i quy\u1ebft 3 v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p trong b\u1ea3ng t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch khai th\u00e1c Data Validation \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u su\u1ea5t cho c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 nh\u1eadp li\u1ec7u.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><b>T\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng<\/b> b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet<\/strong><\/h3>\n\n\n\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t c\u1ee7a Data Validation l\u00e0 t\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng (drop-down list). Khi <\/span>\u0111\u00f3<span style=\"font-weight: 400;\">, ng\u01b0\u1eddi d\u00f9ng s\u1ebd l\u1ef1a ch\u1ecdn t\u1eeb c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c \u0111\u1ecbnh s\u1eb5n trong \u00f4. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 thao t\u00e1c t\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng b\u1eb1ng t\u00ednh n\u0103ng Data Validation.<\/span><\/p>\n\n\n\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400;\">Tr\u01b0\u1edbc ti\u00ean h\u00e3y <\/span><b>ch\u1ecdn v\u00f9ng<\/b><span style=\"font-weight: 400;\"> b\u1ea1n mu\u1ed1n t\u1ea1o danh s\u00e1ch drop-down d\u1eef li\u1ec7u<\/span>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-1.png\" alt=\"Ch\u1ecdn v\u00f9ng b\u1ea1n mu\u1ed1n \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n t\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng.\" class=\"wp-image-36928\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-1.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-1-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-1-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-1-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-1-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400;\">Sau \u0111\u00f3 b\u1ea1n v\u00e0o <\/span><b>Data<\/b><span style=\"font-weight: 400;\"> (D\u1eef li\u1ec7u) v\u00e0 \u1ea5n ch\u1ecdn <\/span><b>Data Validation <\/b><span style=\"font-weight: 400;\">(X\u00e1c th\u1ef1c d\u1eef li\u1ec7u)<\/span>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-2.png\" alt=\"b\u01b0\u1edbc k\u1ebf ti\u1ebfp C\u00e1ch t\u1ea1o Data Validation trong Google Sheet l\u00e0 ch\u1ecdn t\u00ednh n\u0103ng Data Validation.\" class=\"wp-image-36929\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-2.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-2-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-2-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-2-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-2-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 3: <\/b><span style=\"font-weight: 400;\">Nh\u00ecn qua giao di\u1ec7n hi\u1ec7n l\u00ean \u1edf b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh, ch\u1ecdn ti\u1ebfp <\/span><b>Add rule<\/b><span style=\"font-weight: 400;\"> (Th\u00eam quy t\u1eafc)<\/span>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-3.png\" alt=\"Ch\u1ecdn Add rule \u0111\u1ec3 th\u00eam gi\u00e1 tr\u1ecb th\u1ea3 xu\u1ed1ng trong c\u00e1ch t\u1ea1o Data Validation trong Google Sheet.\" class=\"wp-image-36930\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-3.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-3-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-3-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-3-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-3-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 4:<\/b><span style=\"font-weight: 400;\"> \u1ede \u00f4 Criteria (Ti\u00eau ch\u00ed), b\u1ea1n nh\u1ea5p v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh v\u00e0 ch\u1ecdn <\/span><b>Drop-down<\/b><span style=\"font-weight: 400;\"> (Tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng). Sau \u0111\u00f3, b\u1ea1n nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb cho ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn v\u00e0o \u00f4 <\/span><b>Value<\/b><span style=\"font-weight: 400;\"> (Gi\u00e1 tr\u1ecb). B\u1ea1n c\u00f3 th\u1ec3 th\u00eam gi\u00e1 tr\u1ecb b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o \u00f4 <\/span><b>Add another item<\/b><span style=\"font-weight: 400;\"> (Th\u00eam m\u1ed9t m\u1ee5c kh\u00e1c).<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-4.png\" alt=\"B\u01b0\u1edbc ti\u1ebfp theo trong c\u00e1ch t\u1ea1o Data Validation trong Google Sheet, b\u1ea1n ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng Dropdown v\u00e0 \u0111i\u1ec1n c\u00e1c d\u1eef li\u1ec7u v\u00e0o.\" class=\"wp-image-36931\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-4.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-4-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-4-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-4-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-4-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 5: <\/b><span style=\"font-weight: 400;\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh \u0111i\u1ec1u ki\u1ec7n cho danh s\u00e1ch b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o <\/span><b>Advanced options<\/b><span style=\"font-weight: 400;\"> (T\u00f9y ch\u1ec9nh n\u00e2ng cao). Sau khi \u0111i\u1ec1u ch\u1ec9nh theo \u00fd mu\u1ed1n, b\u1ea1n nh\u1ea5p v\u00e0o<\/span> \u00f4<span style=\"font-weight: 400;\"> <\/span><b>Done<\/b><span style=\"font-weight: 400;\"> (Xong) \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-5.png\" alt=\"B\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh th\u00eam \u0111\u1ecbnh d\u1ea1ng c\u00e1o c\u1ea5p t\u1ea1i \u00f4 Advanced options. CH\u1ecdn Done \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00e1ch t\u1ea1o Data Validation trong Google Sheet.\" class=\"wp-image-36932\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-5.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-5-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-5-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-5-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-danh-sach-tha-xuong-5-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><b>Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u nh\u1eadp v\u00e0o<\/b><\/h3>\n\n\n\n<p><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 \u0111\u01b0\u1ee3c nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb trong y\u00eau <\/span>c\u1ea7u<span style=\"font-weight: 400;\"> nh\u1ea5t \u0111\u1ecbnh. Vi\u1ec7c n\u00e0y gi\u00fap tr\u00e1nh nh\u1eefng l\u1ed7i do nh\u1eadp li\u1ec7u sai, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong c\u00e1c b\u1ea3ng t\u00ednh y\u00eau c\u1ea7u d\u1eef li\u1ec7u ch\u00ednh x\u00e1c v\u00e0 c\u00f3 c\u1ea5u tr\u00fac c\u1ee5 th\u1ec3.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400;\">C\u00e1ch s\u1eed d\u1ee5ng Data Validation khi c\u1ea7n gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u nh\u1eadp v\u00e0o t\u01b0\u01a1ng t\u01b0 nh\u01b0 t\u1ea1o danh s\u00e1ch th\u1ea3 xu\u1ed1ng. Khi \u0111\u1ebfn b\u01b0\u1edbc ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng, b\u1ea1n h\u00e3y thay \u0111\u1ed5i t\u00f9y ch\u1ecdn theo d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n. V\u00ed d\u1ee5 b\u1ea1n ch\u1ec9 mu\u1ed1n nh\u1eadn n\u0103m sinh trong kho\u1ea3ng 1900 \u0111\u1ebfn 2000, h\u00e3y l\u00e0m nh\u01b0 sau.<\/span><\/p>\n\n\n\n<p><b>B\u01b0\u1edbc 1:<\/b><span style=\"font-weight: 400;\"> T\u1ea1i tr\u00ecnh duy\u1ec7t n\u00e0y, b\u1ea1n \u1ea5n v\u00e0o m\u0169i t\u00ean v\u00e0 l\u01b0\u1edbt <\/span><b>ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n<\/b><span style=\"font-weight: 400;\"> b\u1ea1n mu\u1ed1n gi\u1edbi h\u1ea1n.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-1.png\" alt=\"\u1ede \u00f4 Criteria, b\u1ea1n nh\u1ea5n v\u00e0o m\u0169i t\u00ean th\u1ea3 xu\u1ed1ng r\u1ed3i t\u00ecm ch\u1ecdn \u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n gi\u1edbi h\u1ea1n.\" class=\"wp-image-36933\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-1.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-1-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-1-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-1-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-1-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400;\">\u0110i\u1ec1n gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n b\u1ea1n \u0111\u01b0a ra v\u00e0o \u00f4 <\/span><b>Value or formula<\/b><span style=\"font-weight: 400;\"> (Gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f4ng th\u1ee9c).<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-2.png\" alt=\"B\u1ea1n \u0111i\u1ec1n \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c d\u1eef li\u1ec7u gi\u1edbi h\u1ea1n v\u00e0o \u00f4 Gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f4ng th\u1ee9c.\" class=\"wp-image-36934\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-2.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-2-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-2-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-2-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-2-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<p><b>B\u01b0\u1edbc 3: <\/b><span style=\"font-weight: 400;\">\u0110i\u1ec1u ch\u1ec9nh c\u00e1ch hi\u1ec3n th\u1ecb khi ng\u01b0\u1eddi d\u00f9ng nh\u1eadp sai d\u1eef li\u1ec7u t\u1ea1i<\/span><b> Advanced options <\/b><span style=\"font-weight: 400;\">(T\u00f9y ch\u1ec9nh n\u00e2ng cao). B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t c\u1ea3nh b\u00e1o ho\u1eb7c t\u1eeb ch\u1ed1i d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o sai \u0111i\u1ec1u ki\u1ec7n. Nh\u1ea5n <\/span><b>Done<\/b><span style=\"font-weight: 400;\"> (Xong) l\u00e0 ho\u00e0n t\u1ea5t.<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-3.png\" alt=\"Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh khi d\u1eef li\u1ec7u nh\u1eadp sai t\u1ea1i Advanced options. Cu\u1ed1i c\u00f9ng nh\u1ea5n Done l\u00e0 ho\u00e0n t\u1ea5t c\u00e1ch t\u1ea1o Data Validation trong Google Sheet.\" class=\"wp-image-36935\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-3.png 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-3-300x167.png 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-3-218x121.png 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-3-436x242.png 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-gioi-han-du-lieu-nhap-vao-3-720x401.png 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><b>Ki\u1ec3m tra d\u1eef li\u1ec7u d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c t\u00f9y ch\u1ec9nh<\/b><\/h3>\n\n\n\n<p><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, Data Validation c\u00f2n \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng \u0111\u1ec3 ki\u1ec3m tra t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o. Khi b\u1ea1n c\u00e0i \u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n cho \u00f4 nh\u01b0 thao t\u00e1c tr\u00ean, d\u1eef li\u1ec7u nh\u1eadp v\u00e0o b\u1ecb l\u1ed7i s\u1ebd hi\u1ec3n th\u1ecb r\u00f5 r\u00e0ng. Qua \u0111\u00f3, b\u1ea1n s\u1ebd d\u1ec5 d\u00e0ng ki\u1ec3m tra \u0111\u1ecbnh d\u1ea1ng v\u00e0 gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u theo c\u00f4ng th\u1ee9c ban \u0111\u1ea7u.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n\n\n\n<p><strong>C<b>\u00e1ch<\/b><\/strong><b> t\u1ea1o Data Validation trong Google Sheet<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t <\/span>k\u1ef9 n\u0103ng c\u1ea7n n\u1eafm v\u1eefng<span style=\"font-weight: 400;\"> khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. T\u00ednh n\u0103ng n\u00e0y gi\u00fap n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 s\u1eed d\u1ee5ng d\u1eef li\u1ec7u. N\u1ebfu c\u00f2n b\u1ea5t k\u1ef3 th\u1eafc m\u1eafc n\u00e0o, h\u00e3y \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi cho Adsplus gi\u1ea3i \u0111\u00e1p.\u00a0<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/adsplus.vn\/\"><b>Adsplus.vn<\/b><\/a><b>&nbsp;<\/b><\/h3>\n\n\n\n<p><i><span style=\"font-weight: 400;\">C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 xem b\u00e0i vi\u1ebft n\u00e0y.<\/span><\/i> <i><span style=\"font-weight: 400;\">H\u00e3y c\u1eadp nh\u1eadt th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u1eeb Adsplus \u0111\u1ec3 bi\u1ebft th\u00eam nh\u1eefng th\u00f4ng tin m\u1edbi nh\u1ea5t v\u1ec1 Marketing.<\/span><\/i><span style=\"font-weight: 400;\"> V<\/span><i><span style=\"font-weight: 400;\">\u00e0 c\u00e1c Tips ch\u1ea1y qu\u1ea3ng c\u00e1o hi\u1ec7u qu\u1ea3.<\/span><\/i><span style=\"font-weight: 400;\">&nbsp;<\/span><\/p>\n\n\n\n<ul>\n<li><span style=\"font-weight: 400;\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">Tham kh\u1ea3o c\u00e1c kh\u00f3a h\u1ecdc Google Ads, Facebook Ads t\u1ea1i<\/mark><\/span><a href=\"https:\/\/guru.edu.vn\/\"> <span style=\"font-weight: 400;\">guru.edu.vn<\/span><\/a><\/li>\n\n\n\n<li><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">Tham kh\u1ea3o c\u00e1c g\u00f3i setup t\u00e0i kho\u1ea3n qu\u1ea3ng c\u00e1o Google Ads, Facebook Ads t\u1ea1i<\/mark><a style=\"font-size: revert;\" href=\"https:\/\/hubs.la\/H0BrYSB0\"> <span>1ad.vn<\/span><\/a><\/li>\n<\/ul>\n\n\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch t\u1ea1o Data Validation trong Google Sheet l\u00e0 k\u1ef9 n\u0103ng \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng nhi\u1ec1u trong c\u00f4ng vi\u1ec7c th\u01b0\u1eddng ng\u00e0y. T\u00ednh n\u0103ng n\u00e0y h\u1ed7 tr\u1ee3 s\u1eafp x\u1ebfp, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft \u1ee9ng d\u1ee5ng Data Validation trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0o, h\u00e3y xem ngay th\u00f4ng [&hellip;]<\/p>\n","protected":false},"author":72,"featured_media":36927,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1154],"tags":[1049,1053],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet<\/title>\n<meta name=\"description\" content=\"C\u00e1ch t\u1ea1o Data Validation trong Google Sheet \u00e1p d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Xem ngay c\u00e1ch \u1ee9ng d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y t\u1ea1i \u0111\u00e2y!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch t\u1ea1o Data Validation trong Google Sheet \u00e1p d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Xem ngay c\u00e1ch \u1ee9ng d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y t\u1ea1i \u0111\u00e2y!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet\" \/>\n<meta property=\"og:site_name\" content=\"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/AdsplusVietnam\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-04T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-29T09:53:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb.png\" \/>\n\t<meta property=\"og:image:width\" content=\"722\" \/>\n\t<meta property=\"og:image:height\" content=\"401\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dung\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dung\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet\",\"url\":\"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet\",\"name\":\"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet\",\"isPartOf\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/#website\"},\"datePublished\":\"2024-08-04T07:00:00+00:00\",\"dateModified\":\"2024-07-29T09:53:31+00:00\",\"author\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854\"},\"description\":\"C\u00e1ch t\u1ea1o Data Validation trong Google Sheet \u00e1p d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Xem ngay c\u00e1ch \u1ee9ng d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y t\u1ea1i \u0111\u00e2y!\",\"breadcrumb\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/adsplus.vn\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#website\",\"url\":\"https:\/\/adsplus.vn\/blog\/\",\"name\":\"Adsplus Blog\",\"description\":\"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/adsplus.vn\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854\",\"name\":\"Dung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g\",\"caption\":\"Dung\"},\"url\":\"https:\/\/adsplus.vn\/blog\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet","description":"C\u00e1ch t\u1ea1o Data Validation trong Google Sheet \u00e1p d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Xem ngay c\u00e1ch \u1ee9ng d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y t\u1ea1i \u0111\u00e2y!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet","og_locale":"vi_VN","og_type":"article","og_title":"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet","og_description":"C\u00e1ch t\u1ea1o Data Validation trong Google Sheet \u00e1p d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Xem ngay c\u00e1ch \u1ee9ng d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y t\u1ea1i \u0111\u00e2y!","og_url":"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet","og_site_name":"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online","article_publisher":"https:\/\/www.facebook.com\/AdsplusVietnam\/","article_published_time":"2024-08-04T07:00:00+00:00","article_modified_time":"2024-07-29T09:53:31+00:00","og_image":[{"width":722,"height":401,"url":"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2024\/07\/cach-tao-data-validation-trong-google-sheet-thumb.png","type":"image\/png"}],"author":"Dung","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dung","Est. reading time":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet","url":"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet","name":"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet","isPartOf":{"@id":"https:\/\/adsplus.vn\/blog\/#website"},"datePublished":"2024-08-04T07:00:00+00:00","dateModified":"2024-07-29T09:53:31+00:00","author":{"@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854"},"description":"C\u00e1ch t\u1ea1o Data Validation trong Google Sheet \u00e1p d\u1ee5ng nhi\u1ec1u trong vi\u1ec7c qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Xem ngay c\u00e1ch \u1ee9ng d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y t\u1ea1i \u0111\u00e2y!","breadcrumb":{"@id":"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adsplus.vn\/blog\/cach-tao-data-validation-trong-google-sheet#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/adsplus.vn\/blog\/"},{"@type":"ListItem","position":2,"name":"Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3 b\u1eb1ng c\u00e1ch t\u1ea1o Data Validation trong Google Sheet"}]},{"@type":"WebSite","@id":"https:\/\/adsplus.vn\/blog\/#website","url":"https:\/\/adsplus.vn\/blog\/","name":"Adsplus Blog","description":"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adsplus.vn\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854","name":"Dung","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g","caption":"Dung"},"url":"https:\/\/adsplus.vn\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts\/36926"}],"collection":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/users\/72"}],"replies":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/comments?post=36926"}],"version-history":[{"count":0,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts\/36926\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/media\/36927"}],"wp:attachment":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/media?parent=36926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/categories?post=36926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/tags?post=36926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}