{"id":771,"date":"2023-02-02T11:22:14","date_gmt":"2023-02-02T17:22:14","guid":{"rendered":"http:\/\/www.perceptivepetal.com\/wordpress\/?p=771"},"modified":"2023-02-02T11:23:33","modified_gmt":"2023-02-02T17:23:33","slug":"why-i-put-things-in-my-blog-%f0%9f%a4%af","status":"publish","type":"post","link":"https:\/\/www.perceptivepetal.com\/wordpress\/why-i-put-things-in-my-blog-%f0%9f%a4%af\/","title":{"rendered":"Why I Put Things in My Blog &#x1f92f;"},"content":{"rendered":"\n<p>When I figure something out that I need to remember in the future, I blog about it!  Well, that just happened today.  It&#8217;s Girl Scout Day Camp registration time again, and I keep forgetting how to change blanks to 0&#8217;s in a Google Sheets.  Well, I have that <a href=\"https:\/\/www.perceptivepetal.com\/wordpress\/replacing-blanks-with-zeroes-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">on my blog<\/a>!  So, I just looked it up and quickly had my answer.  This year, I wanted to do some conditional formatting, so this is what I did:<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" loading=\"lazy\" width=\"292\" height=\"397\" src=\"https:\/\/www.perceptivepetal.com\/wordpress\/wp-content\/uploads\/2023\/02\/condformat.png\" alt=\"\" class=\"wp-image-772 size-full\" srcset=\"https:\/\/www.perceptivepetal.com\/wordpress\/wp-content\/uploads\/2023\/02\/condformat.png 292w, https:\/\/www.perceptivepetal.com\/wordpress\/wp-content\/uploads\/2023\/02\/condformat-221x300.png 221w\" sizes=\"(max-width: 292px) 100vw, 292px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p><\/p>\n<\/div><\/div>\n\n\n\n<p>The thing that stumped me was that I needed to put the = sign in front of the field that I was comparing to.  I had already figured out that I needed to stay in the column which is why the $ precedes the cell reference.<\/p>\n\n\n\n<p>Now, I have this documented on my blog&#8230;for when I need it next year.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When I figure something out that I need to remember in the future, I blog about it! Well, that just happened today. It&#8217;s Girl Scout Day Camp registration time again, and I keep forgetting how to change blanks to 0&#8217;s in a Google Sheets. Well, I have that on my blog! So, I just looked&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[148,147],"_links":{"self":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/771"}],"collection":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/comments?post=771"}],"version-history":[{"count":2,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/771\/revisions"}],"predecessor-version":[{"id":774,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/posts\/771\/revisions\/774"}],"wp:attachment":[{"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/media?parent=771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/categories?post=771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perceptivepetal.com\/wordpress\/wp-json\/wp\/v2\/tags?post=771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}