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?
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?