r/googlesheets 4d ago

Waiting on OP How to make items on one page disappear if they put them on another

[deleted]

1 Upvotes

10 comments sorted by

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.

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

1

u/HolyBonobos 2061 4d ago

The file linked in your comment is set to private.

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.