Hey everyone! I'm trying to create a script in Google Sheets that updates the 'Next Due' date automatically when I select 'Paid' from a dropdown in the 'Status' column. My sheet has a column for 'Frequency' which can be 'Weekly', 'Monthly', 'Yearly', etc. For example, if I select 'Paid' and the current date is 09/09/2025 with a frequency of 'Weekly', I want it to update to 16/09/2025. I've written some code for it, but nothing happens when I make my selection. I've pasted the code below along with a link to my sheet. Can someone help me figure out what's going wrong? Thanks!
2 Answers
Maybe try learning a bit about coding before jumping into scripts. Understanding the basics could really help you debug issues like this in the future.
It looks like you've got a typo in your code. You're using 'today' to set the next due date, but you actually need to use 'current'. Also, check if you really need that nested function—removing it might help!
I get your point, but I have no background in coding at all! I thought starting with some script examples would help me learn, but I'm struggling. That's why I'm here asking for guidance.