Tips for using shar...
 
Notifications
Clear all

Tips for using shared spreadsheets to avoid duplicate holiday presents?

3 Posts
4 Users
0 Reactions
21 Views
0
Topic starter

Last year was a total disaster because my sister and I both bought our nephew the exact same lego set for Christmas and it was so awkward when he opened both. I really want to avoid that this year since I have about five people to buy for on a tight budget and I heard people use like shared spreadsheets for this? I have literally no idea how those work though or how to set one up so everyone can see it without accidentally deleting what someone else wrote. Sorry if this is a dumb question but is there a simple way to do this for someone who is terrible with computers? I dont want to break the file...


3 Answers
12

Honestly, I have been using shared sheets for years now and it saved my sanity after my family kept buying the same books. Google Sheets is basically your best friend here. Dont overthink it or youll get a headache... just keep it simple. In my experience, here is how you do it without breaking everything:

  • Create three columns: Person, Gift Idea, and Claimed By.
  • Go to Share and make sure it says Anyone with the link can edit.
  • Tell everyone to just type their name in the Claimed By column as soon as they buy it. I have tried many methods but the spreadsheet is just faster. If you are worried about someone deleting stuff, you can right-click a cell and select Protect range to lock the headers so they stay put. It sounds techy but its really just a few clicks. Total lifesaver for those of us on a budget who cant afford mistakes like double legos lol.


12

Late to the party but I am absolutely obsessed with using shared sheets for the holidays! It is such a fantastic way to stay organized! ^ This. Also, if you are worried about someone accidentally deleting your hard work, you should definitely look into these safety features to keep everything secure:

  • Use the Version History tool under the File menu. This is a total lifesaver because it allows you to restore an older version if anyone makes a mistake!
  • Try the Protect Sheets and Ranges feature. You can literally lock specific columns so nobody can edit your personal budget or ideas.
  • Honestly, consider using a dedicated tool like ShareProduct's wishlist maker instead of a raw sheet. It is amazing because it handles the sync issues for you without any risk of breaking formulas... I love how much stress this removes! It makes the whole process so much more efficient and fun for everyone involved! Just take it one step at a time and you wont have any issues at all!


3

Ngl I was terrified of breaking the family spreadsheet last year too. It feels like one wrong click and boom, everything is gone... kinda stressful when you are on a budget and cant afford mistakes. If you are worried about the tech side, here is how I see the options:

  • Google Sheets: Totally free and great for seeing everything at once. Problem is, if someone isnt careful, they could delete your whole row. It happens.
  • Dedicated Gifting Apps: These are basically idiot-proof. You just tap a button to claim an item. Its free too, which is nice, but everyone has to make an account which can be a pain for some.
  • Shared Notes: If you have an iPhone, just use the Notes app. Super simple, but way less organized than a sheet. Honestly, apps are safer if you dont want to mess up a file. Spreadsheets are great but definitely feel more risky if you arent a computer whiz...


Share:
Forum.CanonRumors.CO is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.