Sometimes you want to share a Google Spreadsheet with someone but you don’t want them to change your version. Maybe you’re sharing an order form (just like in this week’s tip!) with many clients and you need to get back a unique form from each person. Or you find a fantastic Google Spreadsheet that you … More FSA Tip #13 Working With VIEW ONLY Google Spreadsheets
It’s pretty easy to refer to something in your spreadsheet. You refer to numbers all the time, and you probably refer to text at times. But there are other times when you need to refer to NOTHING in your formulas or spreadsheets. This can happen with the SUBSTITUTE formula (in fact this is this tip’s … More FSA Tip #12 Referring To “NOTHING” In Formulas
Here is a TWO FORMULA COUNTING COMBO to count how many time something repeats in a spreadsheet cell. We’ll use this in a hashtag counter as part of your farm social media plan. You might have a few questions right now. What’s a hashtag counter? Different social media gurus recommend different numbers of hashtags for … More FSA Tip #11 Counting Hashtags
Sometimes you need a fancy formula to get your spreadsheet to tell you what you want to know. And sometimes the information is just sitting there in plain sight Today’s tip is one of the plain sight kind! In this tip, we’ll use a market sales log to Discover the SUM box in your status … More FSA Tip #10 The SUM Box In Your Status Bar
So, your farm has a monster spreadsheet that lets you plan everything down to the finest detail but you hate looking at hundreds and thousands of rows? You will love using filters! Filters are a spreadsheet tool that let you view segments of your information without distorting your information. In this tip, we’ll use a … More FSA Tip #9 How To Filter Your Spreadsheets
You probably spend a lot of time scrolling through spreadsheets with your mouse clicking on this cell or that. Have you ever wished you could get to the right cell quicker? If so, this tip if for you! It covers 3 keyboard shortcuts to scoot around your spreadsheets and 1 bonus shortcut that lets you … More FSA Tip #8 Quickly Navigate Your Spreadsheets With Keyboard Shortcuts
This farm spreadsheet tip goes back to basics. Before you start setting up your Farm Spreadsheet System, you’ve got to decide on a spreadsheet application. Where to start among all the available options? I’ve got 5 considerations for you to evaluate different spreadsheet apps. I also explain why I use Google Sheets for my farm … More FSA Tip #7 How To Choose A Spreadsheet System
