Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 296: The Big (Formula) Reveal!
|
Welcome to the Google Sheets Tips newsletter #296, your Monday morning espresso, in spreadsheet form! A big thank you to this week's sponsors who help keep this newsletter free to read: _______ ➜ NewsI. Read more >> (second story) II. This story tells how the Williams F1 Racing team used a gigantic Excel spreadsheet to manage the parts list for their F1 racing cars. In preparation for the 2024 racing season however, they modernized their operations and upgraded away from spreadsheets. _______ ➜ Google Sheets Tip #296: The Big Reveal! A.k.a. how to show formulasIn this tip, we look at two methods to view formulas in our Sheets. Of course, we can always see any individual formula in the formula bar above our grid: In this case, we are looking at a CHOOSE function. But sometimes it's helpful to see multiple formulas and know where they are in our Sheet. For that, we have two techniques at our disposal: 1. Show FormulasTo show all the formulas, go to the menu: View > Show > Formulas or use the shortcut Ctrl + ` In our Sheet, all the formulas will now show up (you might need to resize the cells to see them fully): To return to the results, uncheck Formulas in the View menu again. Easy! 2. Show Formulas with the FORMULATEXT functionIn addition to the menu option, we have a function dedicated to revealing formulas! Suppose you have a formula in cell C2, then use this formula to reveal that formula: =FORMULATEXT(C2) In our Sheet, it looks something like this: The nice thing about FORMULATEXT is that we can combine it with other formulas. For example, we can add a checkbox to cell D1 and an IF statement to toggle the formula views on/off! The formula in cell D2 in this example is: =IF( $D$1 , FORMULATEXT(C2) , ) Happy Formula Auditing! _______ If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a great week! Cheers, |
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Hi Reader, Welcome to the Google Sheets Tips newsletter #383, your Monday morning espresso, in spreadsheet form! NASA's Artemis II mission blasted off towards the moon last week. I watched the launch live with my son (on YouTube, not in person, haha). The launch was exhilarating; I was holding my breath for the 10-second countdown! I'm excited to follow along with the remainder of the mission and see close-up images of the moon. In fact, as I press send on this email, they are scheduled to...
Hi Reader, Welcome to the Google Sheets Tips newsletter #382, your Monday morning espresso, in spreadsheet form! If you feel like the AI wave is moving faster than you can keep up with, you aren't alone. The gap between "playing with a chatbot" and "building reliable AI systems" feels wider than ever, and that feeling is only increasing with every new AI announcement. For the past couple of months, I’ve been working on a new course to help address this challenge. Next Monday, I’m opening...
Hi Reader, Welcome to the Google Sheets Tips newsletter #381, your Monday morning espresso, in spreadsheet form! Since last week, the weather in the Mid-Atlantic region has been even more volatile than that mission critical spreadsheet your non-technical boss "fixed" recently. We had a day over 80F, followed by a wild 50F drop to temps in the 30's and snow squalls. And later today, we're forecast to have a severe thunderstorm and possible tornadoes. It's threatening enough that schools in...