Google sheets project
Thanh toán khi bàn giao
Currently use Google sheets for my company but need to organize it better. First column A is status, column B is Representative Name, column C is name of customer, column D is the date the customer was added, column e is blank, Column F is marketing source, column G is amount of column from J -AO that we color green Column H is amount of columns J-AO that we calculate Red. This is a shared Google sheets which can only be edited by admin although all representatives of our company can view it. What I need is filters so each representative can from a drop down select there name and only there deals will show up, and filters that if column A is colored red we can filter all the reds or all the greens and so on. Once the right person is selected I can show a sample of how the spreadsheet is now so it will be easier to explain.
ID dự án: #36687761
Về dự án
137 freelancer chào giá trung bình$124 cho công việc này
Hello, I can help you with your project. I have Google sheets and Excel experience. Though most of my 18 years of experience is in English I have also studied and used Google Sheets.
I understood the required filters and functionality. By giving a password column and using yhat password, name representatives can view their records. I am interested to work on the project. Please message me. Thanks.