If you don’t know about Data Validation in spreadsheets, this tool will blow your mind! With Data Validation, you can make sure your users enter information into cells the right way. There are different options to use Data Validation, but the one we explore in the video is to create a drop-down menu for each … More FSA Tip #14 Data Validation
This week, we take a break from our regularly scheduled Farmer Spreadsheet Tip to announce the A 4-part online mini course for market gardeners who dream about saving some of their own seeds. The first class is just before the new year. Just in time to plan your 2020 growing season! Dec. 30 Why Grow … More Announcing the Seed Saving for Market Growers FREE Mini Course
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
