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
Anchoring cells in a formula ensures that you are referring to the right cells when you reuse the same formulas elsewhere in your spreadsheet. … More FSA Tip #5 Anchoring Cells
SUMIF let’s you SUM up certain cells IF they meet certain conditions. … More FSA Tip #4 Sumif and Sumifs!
This week’s farmer spreadsheet tip is about using week numbers instead of dates in your spreadsheets. Week numbers are a critical piece of how I crop plan. They make it much easier to sort and look at information on a weekly basis rather then get bogged down with how there are 7 different days in each week. Are … More FSA Tip #3 Week Numbers
Earlier in the year, I wrote about how we evaluate Tomato varieties with easy trials. Our lettuce trials are even simpler! Trial Goal I wanted small dense lettuce heads that didn’t take too much space in the garden but gave fantastic salads! That doesn’t seem like too much to ask for. We went through seed … More Evaluating Quick Lettuce Trials