The way to do it in the cell is =SUM(OTHERSHEET!C2:C200) where ‘other sheet,’ is the other sheet you are messing with by name. I rename them because of minor glitches across browsers.<\/p>\n","protected":false},"excerpt":{"rendered":"
Setting goals: whatever gets measured gets improved. So, if we want to get after it, live a life of splendor, we want to track some of our inputs, the 2.0 way. It’s lightweight, it’s custom, and it utterly rocks. We want to track stuff so we live in reality. Ask failure agents and they always […]<\/p>\n","protected":false},"author":39,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_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":""},"categories":[7,212],"tags":[210,270,144,137,271],"class_list":{"0":"post-5615","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-enduring-interest","7":"category-flourishing","8":"tag-broker","9":"tag-docs","10":"tag-goals","11":"tag-google","12":"tag-google-docs","14":"no-featured-image"},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5529,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/5529\/using-google-docs-to-tracking-your-goals-for-2008-part-1-of-3-maybe-4\/","url_meta":{"origin":5615,"position":0},"title":"Using Google Docs to Track Your Goals for 2008: Part 1 of 3, Maybe 4.","author":"Chris Johnson","date":"November 12, 2008","format":false,"excerpt":"Greg and I have talked from time to time about CRMS.\u00a0\u00a0 We both like them in concept, but have a hard time using them.\u00a0\u00a0 He doesn't use REST, and I don't use HEAP.\u00a0\u00a0 I have been using my blackberry to track stuff, aweber, and that's it.\u00a0\u00a0 But I needed a\u2026","rel":"","context":"In "Real Estate"","block_context":{"text":"Real Estate","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/real-estate\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5683,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/5683\/setting-goals-part-3-of-4\/","url_meta":{"origin":5615,"position":1},"title":"Setting Goals Part 3 of 4.","author":"Chris Johnson","date":"November 19, 2008","format":false,"excerpt":"Seeking splendor requires going after the best there is, not merely the best you think you can do. Holding yourself to the highest possible standards, and that's what BHB is all about. We want to make sure that everyone with the stones to get after a life of freedom and\u2026","rel":"","context":"In "Real Estate"","block_context":{"text":"Real Estate","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/real-estate\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7963,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/7963\/finally-a-heap-of-daylite-at-the-end-of-the-tunnel-finding-a-crm-that-doesnt-blow\/","url_meta":{"origin":5615,"position":2},"title":"Finally: A Heap of Daylite at the end of the tunnel (Finding a CRM that doesn’t blow)","author":"Chris Johnson","date":"April 18, 2009","format":false,"excerpt":"Let me be honest.\u00a0 I've been using Google Docs as my CRM for a while.\u00a0 It's been fast--I've got it mapped to a hotkey, and also on my Mac's dashboard.\u00a0 I can collect info on clients, contacts fast.\u00a0 And I can highlight the ones I follow up with, owe something\u2026","rel":"","context":"In "CRM"","block_context":{"text":"CRM","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/crm\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9344,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/9344\/binghoo\/","url_meta":{"origin":5615,"position":3},"title":"BingHoo","author":"John Rowles","date":"July 29, 2009","format":false,"excerpt":"It's official, Yahoo, the original search brand, is outsourcing its search function to Microsoft. I don't think either Microsoft or Yahoo had a choice. It's a shotgun marriage. Those work out all the time, right? Coming out with something that is noticeably better than Google's Search experience is the only\u2026","rel":"","context":"In "Bloodhound SEO"","block_context":{"text":"Bloodhound SEO","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/bloodhound-seo\/"},"img":{"alt_text":"ballmer-talosian","src":"https:\/\/i0.wp.com\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-content\/uploads\/2009\/07\/ballmer-talosian.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3368,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/3368\/is-hyper-transparency-a-cover-for-mediocrity\/","url_meta":{"origin":5615,"position":4},"title":"Is Hyper-Transparency A Cover For Mediocrity ?","author":"Brian Brady","date":"July 16, 2008","format":false,"excerpt":"Which one of these loans is better? A- Loan docs at 6.5% with 1 point cost, disclosed at 6.5% with 1 point cost 30 days earlier...OR... B- Loan docs at 6.5% with 1 point cost, disclosed at 6.25% with 1 point cost, 30 days earlier,\u00a0 but the originating broker negotiated\u2026","rel":"","context":"In "Real Estate"","block_context":{"text":"Real Estate","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/real-estate\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5469,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/5469\/51-days-till-2009-what-are-you-doing-about-it\/","url_meta":{"origin":5615,"position":5},"title":"51 Days till 2009: What Are You Doing About it?","author":"Chris Johnson","date":"November 10, 2008","format":false,"excerpt":"This year is racing to a close.\u00a0\u00a0 But we are still needing to eat, and we're trying to survive what (in many ways, statistically) is the worst year in a while.\u00a0\u00a0 But, let's figure out this year and suck every drop of marrow out of it: There are 51 days\u2026","rel":"","context":"In "Egoism in Action"","block_context":{"text":"Egoism in Action","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/egoism-in-action\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/5615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/comments?post=5615"}],"version-history":[{"count":5,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/5615\/revisions"}],"predecessor-version":[{"id":5619,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/5615\/revisions\/5619"}],"wp:attachment":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/media?parent=5615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/categories?post=5615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/tags?post=5615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}