{"id":9353,"date":"2020-08-30T14:43:24","date_gmt":"2020-08-30T05:43:24","guid":{"rendered":"https:\/\/www.trimir.net\/?p=9353"},"modified":"2020-08-30T14:45:08","modified_gmt":"2020-08-30T05:45:08","slug":"data-validation-in-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.trimir.net\/?p=9353","title":{"rendered":"Data Validation in spreadsheet"},"content":{"rendered":"\n

Sharepoint \uc5d0\uc11c \uc0ac\uc6a9\uc911\uc778 Excel in Office 365 \uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc790\uafb8 \uc0ac\ub77c\uc9c4\ub2e4.<\/p>\n\n\n\n

Google Sheet \ub85c \uc62e\uae38\uae4c \uc774\ud2c0\uc815\ub3c4 \ud14c\uc2a4\ud2b8\ud574\ubcf4\ub2c8, \uc81c\uc77c \ud070 \ubb38\uc81c\uac00 Dropdown List \ub9cc\ub4dc\ub294 \uac83\uc774\ub2e4.<\/p>\n\n\n\n

\n
\"\"<\/a><\/figure><\/div>\n\n\n\n
\"\"<\/a><\/figure><\/div>\n<\/div><\/div>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

Excel\uc5d0\uc11c\ub294 \uc218\uc2dd\uc73c\ub85c \uc9c1\uc811 \ub123\uac70\ub098, Defined Name \uc744 \ud1b5\ud574 \uc778\uc2dd\uc774 \uac00\ub2a5\ud55c\ub370, Google sheet \uc5d0\uc11c\ub294 \uc218\uc2dd \uc9c1\uc811 \uc785\ub825\uc774 \ub418\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n\n\n\n

Dynamic List \ub97c \ub9cc\ub4e4\ub824\uace0 \ud574\ub3c4, \ud589\uc774 \ucd94\uac00\ub418\ub354\ub77c\ub3c4 \ud56d\uc0c1 \uac19\uc740 Range\ub97c \ucc38\uc870\ud558\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0 \uae30\ubcf8\uc801\uc778 \ud568\uc218\ub9cc\uc73c\ub85c\ub294 \ub2f5\uc774 \ub098\uc624\uc9c0\uc54a\ub294\ub2e4. Apps \ub97c \uac00\uc9c0\uace0 \ub9cc\ub4e4\uc5b4 \ubcf4\uc544\ub3c4 \ube44\uc2b7\ud55c \uc0c1\ud669.<\/p>\n\n\n\n

\ub300\uc548\uc73c\ub85c Airtable \uc774\ub77c\ub4e0\uac00 \ub2e4\ub978 \ud234\ub4e4\uc744 \uae30\uc6c3\uac70\ub824 \ubd24\ub294\ub370, Excel \ub9cc\ud55c\uac8c \uc5c6\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

Sharepoint \uc5d0\uc11c \uc0ac\uc6a9\uc911\uc778 Excel in Office 365 \uc5d0\uc11c \ub370\uc774\ud130\uac00 \uc790\uafb8 \uc0ac\ub77c\uc9c4\ub2e4. Google Sheet \ub85c \uc62e\uae38\uae4c \uc774\ud2c0\uc815\ub3c4 \ud14c\uc2a4\ud2b8\ud574\ubcf4\ub2c8, \uc81c\uc77c \ud070 \ubb38\uc81c\uac00 […]<\/p>\n","protected":false},"author":1001002,"featured_media":9356,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8],"tags":[956,958,957],"class_list":["post-9353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mac","tag-excel","tag-google-sheet","tag-957"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/storage.googleapis.com\/wordpress-gallery\/2020\/08\/2b0c41ca-google_sheet_data_validation.png?fit=900%2C515&ssl=1","jetpack-related-posts":[{"id":1026,"url":"https:\/\/www.trimir.net\/?p=1026","url_meta":{"origin":9353,"position":0},"title":"Google Spreadsheets","author":"DS Lee","date":"June 7, 2006","format":false,"excerpt":"\uc2e0\uccad\uc744 \ud588\ub354\ub2c8, \ud558\ub8e8\ub9cc\uc5d0 \ub098\uc628\ub2e4. \ubcf5\uc7a1\ud55c \uac74 \uc4f8 \uc218 \uc5c6\uaca0\uc9c0\ub9cc, \uac04\ub2e8\ud55c \uc6a9\ub3c4\ub098, \uacf5\uc720\ud560 \ud544\uc694\uac00 \uc788\uc744\ub54c\ub294 \uaf64 \uc720\uc6a9\ud55c \uac83 \uac19\ub2e4. \uc598\ub4e4\ub3c4 \ub9d0\uc744 \ud558\ub294 \uac78 \ubcf4\ub2c8, \uaf64\ub098 \uc2e0\uacbd\uc4f0\uc774\ub294 \ubaa8\uc591\uc774\ub2e4. word \ub300\uc6a9\uc73c\ub85c writely. excel \ub300\uc6a9\uc73c\ub85c Google Spreadsheets. google chat\uc774\ub098 rss reader\ub294 \uac70\uc758 \uc4f0\uc9c8 \uc54a\uc9c0\ub9cc, desktop\uc740 \uc774\uc81c\ub294 \uc5c6\uc73c\uba74 \uc548 \ub420 \uc9c0\uacbd. window\uc5d0\uc11c mac\ub9cc\ud07c \ud3b8\ud558\uac8c \uc4f8\ub824\uba74,\u2026","rel":"","context":"In "Mac"","block_context":{"text":"Mac","link":"https:\/\/www.trimir.net\/?cat=8"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":965,"url":"https:\/\/www.trimir.net\/?p=965","url_meta":{"origin":9353,"position":1},"title":"Google Calendar","author":"DS Lee","date":"April 14, 2006","format":false,"excerpt":"Google Calendar iCal\uc758 data\ub97c import or iCal\uc5d0\uc11c import. \uba87\uba87 \ube14\ub85c\uadf8\ub97c \uc77d\uc5b4\ubcf4\uba74, \uc544\uc9c1 \ud55c\uae00\uc740 \uc548\ub428. \ub85c\uae34\ud574\uc11c \uc870\uae08 \uc0ac\uc6a9\ud574\ubcf4\ub2c8.. \uaf64\ub098 \ud3b8\ud558\ub2e4.","rel":"","context":"In "Log"","block_context":{"text":"Log","link":"https:\/\/www.trimir.net\/?cat=7"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5417,"url":"https:\/\/www.trimir.net\/?p=5417","url_meta":{"origin":9353,"position":2},"title":"\uc6cc\ub108\ud06c\ub77c\uc774 \ub79c\uc12c\uc6e8\uc5b4 WannaCry Ransomware","author":"DS Lee","date":"May 21, 2017","format":false,"excerpt":"\uc694\uba70\uce60 \ub79c\uc12c\uc6e8\uc5b4 \uc6cc\ub108\ud06c\ub77c\uc774\ub85c \uc804\uc138\uacc4\uac00 \ub09c\ub9ac\ub2e4. \ub2f9\uc5f0\ud788 \uc9d1\uc5d0\uc11c 365\uc77c \uad74\ub7ec\uac00\ub294 \uc708\ub3c4\uc11c\ubc84\ub97c \uba70\uce60 \uaebc\ub450\uc5c8\ub2e4. \uc8fc\ub9d0\uc5d0 \uc11c\ubc84\ub97c \ucf1c\uace0\ub294 \uc5c5\ub370\uc774\ud2b8\ub97c \ud588\ub354\ub2c8, \ubb34\ub824 1\ub144\uc774 \ub118\uac8c \uc804\ud600 \uc5c5\ub370\uc774\ud2b8\uac00 \uc548\ub418\uc5b4\uc788\uc5c8\ub2e4. \ub2e4\uc6b4\ub85c\ub4dc\ub9cc 1GB\uac00 \ub118\uac8c \ubc1b\ub354\ub77c\ub294.. \ubc14\ub85c \uc790\ub3d9\uc5c5\ub370\uc774\ud2b8\ub85c \uccb4\ud06c\ud574\uc8fc\uace0. \ub2f9\uc7a5 \uaebc\uc57c\ud55c\ub2e4\ub294 'SMB1.0\/CIFS \ud30c\uc77c \uacf5\uc720 \uc9c0\uc6d0'\uc744 \uccb4\ud06c \ud574\uc81c\ud588\ub2e4. \uc5ec\uae30\uc11c \ubb38\uc81c\uac00.... \ub77c\uc988\ubca0\ub9ac\ud30c\uc774\uc758 Kodi\uc5d0\uc11c \ubcf4\ub358 Windows Share Folder\uac00 \uc5f0\uacb0\uc774 \uc548\ub428. Xpenology\uc5d0\uc11c \uc5ed\uc2dc\u2026","rel":"","context":"In "Mac"","block_context":{"text":"Mac","link":"https:\/\/www.trimir.net\/?cat=8"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":766,"url":"https:\/\/www.trimir.net\/?p=766","url_meta":{"origin":9353,"position":3},"title":"Complete from MT to WordPress","author":"DS Lee","date":"July 30, 2005","format":false,"excerpt":"\uba87 \ubc88\uc758 \ubed8\uc9d3\ub05d\uc5d0 \uc774\uc804 \uc644\ub8cc. \uac11\uc791\uc2a4\ub7f0 MT \uc758 \uacc4\uc18d\ub418\ub294 Internal Error \ub97c \ub354 \uc774\uc0c1 \ucc38\uc744\uc218\uac00 \uc5c6\uc5c8\ub2e4. pM \uc5d0\uc11c MT \ub85c \ubc14\uafb8\ub294\uac83 \ubcf4\ub2e4\ub294 \ud6e8\uc52c \uc27d\ub2e4. 1. \uc6b0\uc120 UTF-8 \ub85c \ub418\uc5b4 \uc788\uae30\uc5d0 Encoding \uc5d0 \uc2e0\uacbd \uc4f8 \ud544\uc694\uac00 \uc5c6\uc5c8\ub2e4. 2. MT \uc5d0\uc11c Export \ud6c4 text editor \ub85c Post Status \ubcc0\uacbd. Category \ubcc0\uacbd. (MT\u2026","rel":"","context":"In "Blog"","block_context":{"text":"Blog","link":"https:\/\/www.trimir.net\/?cat=3"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1359,"url":"https:\/\/www.trimir.net\/?p=1359","url_meta":{"origin":9353,"position":4},"title":"Gmail IMAP \uc9c0\uc6d0","author":"DS Lee","date":"October 30, 2007","format":false,"excerpt":"Gmail\uc5d0\uc11c IMAP\uc744 \uc9c0\uc6d0\ud558\uae38\ub798, \ub35c\ucee5 Mail\uc5d0\uc11c \uc124\uc815\uc744 \ud588\ub2e4\uac00.. \ud55c\uae00\uc774 \ub2e4 \uae68\uc5b4\uc9c0\ub294 \ubc14\ub78c\uc5d0 \uc644\uc804 OTL... \uae30\uc874\uc5d0 POP\ub85c \uc798 \uc0ac\uc6a9\ud558\ub358 \uac83 \ub9c8\uc800 \uc5c9\ub9dd\uc774 \ub418\uc5b4\ubc84\ub9bc. \uc6b0\uc559~~~ \u3160\u3160","rel":"","context":"In "Mac"","block_context":{"text":"Mac","link":"https:\/\/www.trimir.net\/?cat=8"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1481,"url":"https:\/\/www.trimir.net\/?p=1481","url_meta":{"origin":9353,"position":5},"title":"iPod Touch 2.0","author":"DS Lee","date":"July 12, 2008","format":false,"excerpt":"demonoid\uc5d0\uc11c \ub2e4\uc6b4\ubc1b\uc544 \uc124\uce58. 5a347. \ud55c\uae00 \ud0a4\ubcf4\ub4dc\uac00 \uae30\ubcf8\uc73c\ub85c \ub4e4\uc5b4\uac00 \uc788\ub2e4. Jailbreak \uc5d0\uc11c \uc9c0\uc6d0\ud558\ub358 \ub9ce\uc740 \uc5b4\ud50c\uc744 \uc4f8 \uc218\ub294 \uc5c6\uc9c0\ub9cc, \uace7 \ub098\uc624\uaca0\uc9c0.. mail \ub3c4 push \uc11c\ube44\uc2a4 \uc9c0\uc6d0. app store \ub294 \uc758\uc678\ub85c \ube44\uc2fc\uac83\ub4e4\uc774 \uaf64 \uc788\ub124..","rel":"","context":"In "Mac"","block_context":{"text":"Mac","link":"https:\/\/www.trimir.net\/?cat=8"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_shortlink":"https:\/\/wp.me\/p4q7Ev-2qR","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.trimir.net\/index.php?rest_route=\/wp\/v2\/posts\/9353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.trimir.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.trimir.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.trimir.net\/index.php?rest_route=\/wp\/v2\/users\/1001002"}],"replies":[{"embeddable":true,"href":"https:\/\/www.trimir.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9353"}],"version-history":[{"count":2,"href":"https:\/\/www.trimir.net\/index.php?rest_route=\/wp\/v2\/posts\/9353\/revisions"}],"predecessor-version":[{"id":9359,"href":"https:\/\/www.trimir.net\/index.php?rest_route=\/wp\/v2\/posts\/9353\/revisions\/9359"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.trimir.net\/index.php?rest_route=\/wp\/v2\/media\/9356"}],"wp:attachment":[{"href":"https:\/\/www.trimir.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.trimir.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.trimir.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}