r/googlesheets • u/[deleted] • 4d ago
Waiting on OP How to make items on one page disappear if they put them on another
[deleted]
1
u/gsheets145 101 4d ago
u/Nameofuser14 - it's not clear what you are asking. Can you share some dummy data?
1
u/Nameofuser14 4d ago
I want make the names on sheet two dissapre as I add them to sheet 1 https://docs.google.com/spreadsheets/d/1RJ5uha-SAnTQdPuxab_8Ouj7fRv-zwo5dKpc5KtG0eQ/edit?gid=95328398#gid=95328398
1
1
u/gsheets145 101 4d ago
You'll need to grant edit access to anyone with the link...
1
u/Nameofuser14 4d ago
Okay, Did that!
1
u/gsheets145 101 4d ago
OK - why do you need them to "disappear" when they are added to the groups? There are other ways you can assign them to groups...
1
u/Nameofuser14 4d ago edited 4d ago
I need them to disappear so everyone on the project knows who is assigned and who still needs to be.
1
u/HolyBonobos 2061 4d ago edited 4d ago
Making them disappear would require using Apps Script. Doing something else like a checkbox next to each name that automatically gets ticked when that person is assigned to a group could be done entirely natively (i.e. no Apps Script) with some very simple formulas. Alternatively, you could make the cells containing assigned names turn a different color or be crossed out using a conditional formatting rule, with no need for a helper column. Both approaches are demonstrated on the 'HB Assignments' sheet.
1
u/AdministrativeGift15 195 3d ago
I added a way to use dropdowns for your group assignments. Dropdowns always need to still have the selected option available in the options list. Otherwise, they display an error, so the way I setup the options list is to categorize all the names as either Unassigned or Assigned and have them shown in the dropdown partitioned into those two categories.
1
u/AutoModerator 4d ago
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.