I’m having trouble with my Google Sheet. It’s getting really slow because I’m using formulas and App Scripts to add dates when checkboxes are ticked. Does anyone know a faster way to do this? I’ve tried both formulas and scripts, but they’re making my sheet run like molasses. I need something that won’t bog down the whole spreadsheet. Any ideas for a quick method that doesn’t involve formulas or scripts? I’m open to trying new things as long as they keep my sheet running smoothly. Thanks for any help you can give!
In my experience, using a dedicated script triggered only on edits can significantly improve performance over constant recalculation. I replaced conventional formulas with an installable onEdit trigger that writes a static timestamp into a specified cell. This approach avoids the overhead of recalculating an active formula with every change, maintaining responsiveness with large datasets. Separating timestamp entries into a dedicated area can also help minimize delays. This method provided a good balance of automation and efficiency without constantly bogging down the spreadsheet.
hey, have u tried using data validation instead? it’s way faster than formulas or scripts. just set up a dropdown with today’s date as an option. when u check the box, pick the date from the dropdown. no lag, and u can update it manually if needed. might be worth a shot!
I’ve faced similar issues and found a workaround that might help. Instead of relying on formulas or scripts, I now use a separate ‘Date Input’ sheet. When a checkbox is ticked, I manually enter the date in this sheet. Then, I use VLOOKUP to pull these dates into my main sheet. This method is much faster as it reduces the number of calculations Google Sheets needs to perform.
To set it up, create a new sheet with columns for your checkbox identifiers and dates. In your main sheet, use VLOOKUP to reference this data. It’s a bit more manual, but it’s saved me hours of frustration with slow-loading sheets. Plus, it gives you more control over date entries and makes it easier to correct any mistakes.