I am trying to create a sheet for my friend and I about some items selling, cost and state (Sold, in sale, etc) and i want to automate my “state” column, which contains dropdown menus with “Sold !”, “waiting for sale…” and “Null” options. I succeed writing the code to change the state depending on the date (if there’s an on-sale date then the option turns to “waiting for sale” and if there’s a sold date the option changes to “Sold !”.