Create links to the first item of each group in Google Sheets
To the Starter Sheet and written Tutorial! : https://yagisanatode.com/2022/09/07/c...
Let's say you have a huge sorted Google Sheet and you want to quickly access the start of each section in the sheet with a handy link. This tutorial shows you two methods for how to do this.
00:00 What we are going to build
01:32 Getting Started
01:52 Create a unique list of classes
02:48 Finding the start row of each class in the Gradebook
05:24 Get the URL to the first cell in the range.
05:49 Adding the hyperlink to the cell
08:02 Combining it all into one formula
13:41 Testing
#GoogleSheets, #spreadsheets #googleworkspace #businessadministration
Watch video Create links to the first item of each group in Google Sheets online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 06 September 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 654 times and liked it 22 visitors.
