Help with formulas in docs.google

For our agency Asianworker, we are looking for a person for telephone outreach to construction and logistics companies in Slovakia. Your tasks will include: Simple cold calling (telephone contact) with construction and logistics companies. Finding out if companies need workers (armored personnel, carpenters, concrete workers, welders, etc.) and presenting our services. Delivering completed contacts (warm leads) to us. No complicated recruitment – just pure communication and lead generation. Financial compensation: 10 EUR for each delivered and verified warm lead. 70 EUR for each successfully closed and signed contract with a client. Requirements: Excellent knowledge of the Slovak language (spoken and written). Communicative, pleasant voice, and willingness to work. Own phone/internet and computer. If you are interested, please send us a message and we will send you the details.

I'm looking for a attentive and systematic assistant to manage the client database of a small coffee business. I need help organizing a simple and clear client accounting system. At the initial stage, this could be a well-set-up Google Sheet, Notion, or an inexpensive CRM. I will consider your suggestions for the most convenient and budget-friendly solution. What needs to be considered for each client: name and contact details; source of inquiry, such as advertising, Instagram, recommendation; date of first contact; what the client purchased; which types and flavor profiles of coffee they liked; method of coffee preparation; history and approximate frequency of orders; date of next contact; comments and important details of correspondence. I'm primarily looking for a reasonable and economical solution for a small business, so expensive and complex CRMs are not being considered at this stage. At the first stage, the main focus is on systematizing information and reminders. Later, we can discuss the independent sending of agreed messages to clients.

It is necessary to set up a CRM system and end-to-end analytics for a service company specializing in appliance repair (Appliance Repair, USA).Current Situation Company website SEO Google Ads Google Business Profile (Google Maps) Facebook / Instagram Ads Ringostat Google Analytics 4 CRM Workiz External online booking system Setmore.com Important: we are not looking for an advertising or SEO specialist. All advertising channels are already operational. It is essential to correctly link all systems together.What Needs to Be Done Analyze the current operation scheme of Workiz and existing integrations. Set up or suggest a CRM (if Workiz does not allow for the necessary functionality). Set up end-to-end analytics between advertising sources, Ringostat, CRM, and Google Analytics. Set up automatic lead creation in CRM from all possible sources. Transfer the source of the inquiry to CRM (Google Ads, Organic, Google Maps, Facebook/Instagram, Direct, Referral, etc.). Check the possibility of integrating the external booking system Setmore.com with CRM. Set up reports or a dashboard where you can see: the number of leads from each source; the status of each lead; conversions; the effectiveness of each advertising channel.Expected Result Ultimately, we want to see a complete picture for each inquiry: where the client came from; through which advertising source; whether a lead was automatically created in CRM; the further status of the lead; statistics and conversions for each channel. If Workiz is not suitable for implementing these tasks, we are open to considering a transition to another CRM if the contractor can offer a more suitable solution and carry out its implementation.When Responding, Please Indicate experience in setting up Workiz (or similar CRMs); experience in implementing end-to-end analytics; experience in integrating Ringostat, Google Analytics, Google Ads, and CRM; which CRMs you would recommend for this task (if not Workiz); estimated cost and time for completion.

A social experiment on female intimacy and trust is being conducted. This scientific study aims to explore the mechanisms of trust formation and emotional closeness in dyads (pairs) of women. The project is approved by the ethics committee/university. Responsibilities/participation format - Participate in a structured online session (in pairs with another participant) under the guidance of researchers. - Perform communicative and cooperative tasks: joint problem-solving, discussion of pre-prepared topics, exercises on empathy and active listening, an experiment with maintaining eye contact, etc. Requirements for participants - Age 18+; identify as female. - Willingness to discuss personal but non-traumatic topics; ability to participate in paired exercises. Any elements of emotional closeness remain within the framework of safe, non-obscene, and scientifically justified procedures. Conditions and compensation - Duration of one session: 60–120 minutes; - Payment/compensation: fixed amount for a successful session (via Safe) - Venue - Telegram; - Confidentiality: personal data is protected; results are published anonymously.