What if you have a list of options in Google Sheets and after each selection you want your list to exclude the previous option selected in the column on the right. In this tutorial, we will cover how to achieve this with the assistance of a helper sheet in Google Sheets.
Check out the written tutorial accompanying this video: yagisanatode.com/2021/07/04/u...
If you like the video, check out my website:
yagisanatode.com/
Here is the link to just Google Sheets tutorials:
yagisanatode.com/google-sheets/
Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects
yagisanatode.teachable.com/p/...
Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.
www.zazzle.com.au/collections...
#GoogleSheets #Spreadsheets #GoogleEdu #administration #datavalidation
00:00 Intro
01:12 Setup the 'Option' sheet
02:11 Setup working sheet
02:26 Create all choices
03:04 Add 1st col dropdown
04:04 Create set 2 choices formula
06:57 option 2 dropdown setup
09:05 Create set 3 choices formula
10:05 Create set 4 choices formula
10:46 Add option 3 & 4 dropdowns
11:51 Test the end result
27 июн 2024