Help using Google Sheets - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: General Coding Help (https://python-forum.io/forum-8.html) +--- Thread: Help using Google Sheets (/thread-38982.html) |
Help using Google Sheets - matheuspimenta - Dec-15-2022 Guys, I would like help for something important from you. I have a spreadsheet in Google Sheets, which I use for CRM, but the stages of the lead funnel is marked with a checkbox. So there is a checkbox for each of the 5 stages that he is in. What am I trying to do now? I created another tab in the spreadsheet with a better CRM template, where instead of checkbox I did the dropdown template. So the person won't need to keep checking several checks, but just choose which funnel stage he is in. However, I have to update the status of all leads from the old spreadsheet to the new one, and doing it manually would take too much time. I thought of making a python script, where it compares the name of the two worksheets and create a condition to mark in the dropdown of the new worksheet, according to the checkboxes that are marked in the old worksheet. Does anyone know how to help me with this? |