Google sheets filter based on cell value jobs

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

You must to be at least 16 years old and live in Latin America or Eastern Europe. ✻ NO EXPERIENCE REQUIRED ✻ You do not need any experience whatsoever, but you must be clever and eager to learn. No. I am *not* being charitable; rather, I am being practical. ✻ PAYING YOU TO LEARN ✻ No. You aren't dreaming. I value intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me will b...

...marketing to help me boost my product sales through Google PPC and SEO optimization. Key Requirements: - Prior experience with Google PPC campaigns and SEO optimization. - Proven track record of boosting product sales through digital marketing efforts. - Ability to suggest and target specific keywords and phrases to improve our online presence. Your responsibilities will include: - Creating and managing PPC campaigns on Google to attract potential customers. - Implementing SEO strategies to increase organic traffic. - Analyzing data and providing reports on the effectiveness of these campaigns. I already have some ideas for keywords and phrases that we could target, but I'm looking for someone with the expertise to refine and expand on ...

...create an informative website on Hostinger. All the necessary project information - including website content, theme (have flier can send to match), logo, and colour scheme - have been collected, finalised and ready for development. The website will include the following pages: - Home page - About Qigong page: What is Qigong, Who Can Practise, What To Expect, Benefits - About Wild Swan Flowing River Qigong page: Aims, Background, About Meetings, About Mark - Upcoming Events page - Contact page - Links page - Notes page While I didn't specify any additional functionality or design preferences, I do expect the website to: - Be intuitive and easy to navigate - Incorporate our company branding (logo, colour scheme) Ideal Skills: - Proficiency in Word Press for hosting on...

... Budget: Please provide a detailed quote for the entire project, including any revisions. Job Description: We are seeking a talented and creative graphic design team to create a professional and visually appealing pamphlet. This pamphlet will be used to showcase the various service plans and benefits offered by our HVAC company. The goal is to clearly communicate the value and benefits of our services to potential and existing customers. Project Scope: Design and Layout: Create a visually appealing and professional design that aligns with our brand identity. The pamphlet should be easy to read and navigate, with clear headings, subheadings, and bullet points. Incorporate high-quality images, icons, and graphics to enhance the visual appeal and readability. Content

I need a designer for a flyer/postcard promoting my service-based business. This piece plays a significant role in announcing our offerings to the market. Key Requirements: - Design should promote our business services effectively. - Match the design color scheme with our existing business logo colors. Ideal Skills: Freelancers with experience in designing marketing/advertising materials, particularly for service-based businesses, will be ideal for this project. A keen sense of color matching and understanding of marketing strategies will be beneficial.

Hallo. I have started a new website, and used a company to take care of google ads, i used so far over 1000 $ and no sale, so want someone to help with setting up all and check all are ok. Need some feedback what is wrong etc.

Help add search filter to iOS Swift App that exposes the selected items in the array (selected indexes) and the selected index if only 1 is returned.

I'm in need of a talented freelancer to assist with content creation. This project is focused on boosting brand awareness and making our products and services more visible to potential customers. Key Responsibilities: - Conceptualize and create compelling content that resonates with our target audience. - Develop engaging written content or video content that clearly communicates our brand message and value proposition. - Ensure that all content aligns with our brand guidelines and voice. Ideal skills and experience: - Proven track record in content creation, preferably with a focus on brand awareness. - Strong writing and/or video production skills. - Ability to understand and effectively communicate brand values. - Experience in a similar project or industry w...

...in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, instead of getting 19.88%, the result I am seeing is 1987.95%. This suggests there might be an error with the data, cell formatting, or an unnoticed issue in the spreadsheet. Specific Tasks: Review the Spreadsheet: Analyze the provided Excel file to ensure all values...

...seasoned web designer to curate a service-based website for both B2B (Business-to-Business) and B2C (Business-to-Consumer) audiences requires a strategic approach to address the distinct needs of each target group. Medical Staffing Agency primarily located in the Midwest current Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in the CMS system. Google Analytics Setup: Integration of Google Analytics for tracking...

I'm looking an illustrator to create captivating illustrations to accompany my children's short story. The project includes a cover and 14 drawings, all tailored towards 4-8 year-olds. As the story revolves around a child's love for football, a basic understanding of the game would be ideal. I'm looking for cartoon style similar to the attached. Other than the front cover, each page should be related to the 4 lines of the story which will be provided but a summary of the story is that a young boy loves playing football and scoring goals, his team enter a tournament and he has to play in goal but becomes the hero.

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

...this many files can be a challenge for an untrained person, and I need an expert on my team. The project requires: - Knowledge and understanding of Kobo E-readers and Sony E-readers - Familiarity with E-book file formats - Able to deliver a precisely organized outcome Handling this quantity of files is no minor task, so I will place high value on the following skills: - Excellent organizational skills to ensure the easy location of each ebook post-transfer. - An understanding of ebook cataloging - managing metadata may become essential - Problem-solving skills, should any issues arise during the transfer process If you can ensure a smooth, error-free transition across devices, I want you on board. This task needs in-depth knowledge, metic...

...searching for a talented graphic designer to work with on a long-term basis, contributing to various projects for my team. The ideal candidate will have the following qualities: - **Experience:** I require someone who has a solid background in graphic design, with a proven track record of successful projects. Your experience should cover a range of graphic design areas, ideally with a specialization in modern and minimalistic styles. - **Creativity:** I need a designer with a knack for generating innovative ideas. A strong creative vision will be a key asset. - **Portfolio:** Please be ready to showcase your portfolio, along with your previous works. This will help me understand your style and experience better. - **Communication:** I value clear and efficient commu...

As a healthcare business, I'm looking for a highly skilled Google Ads expert to help me drive lead generation through our online campaigns. Key Project Details: - **Objective:** I aim to generate a consistent flow of leads to our website based in Delhi NCR Ideal Experience/Skills: - **Proven Track Record:** I'm looking for someone with a strong background in lead generation through Google Ads. Previous experience in the healthcare industry is a plus but not mandatory. - **Analytical Skills:** The ability to analyze ad performance and make data-driven decisions for optimization is crucial. Please be ready to provide examples of successful lead generation campaigns you have run and how you plan to approach this specific project.

I'm currently running Google ads for my business and I want an expert to optimize it. I'm looking for someone who can help me to maximize the effectiveness of my Google Ads campaign.

I'm looking for a professional to verify the phone number for my Google Business profile to enhance its credibility and visibility. Key Requirements: - The verification method should be of Landline number. Ideal Skills and Experience: - Experience in managing Google Business profiles. - Proficiency in verifying phone numbers using SMS. - Knowledge of best practices to increase trust with customers and enhance visibility on Google Business.

I'm looking for a professional WordPress developer who can help me resolve Google Console errors on my website. I'm having trouble with Google Console errors on my WordPress website. I need a skilled developer to solve this issue. They should ensure that I can detect all console errors before submitting to Google. The ideal freelancer should have: - Extensive experience in resolving Google Console errors on WordPress websites If you read the job post carefully mention word #googleconsole on top of the proposal.

I'm currently seeking a professional with extensive experience in structural engineering, especially older homes. My property is an 1890s house in Michigan requiring structure optimization for joist, rafter, and beam/collar tie to better withstand our moderate winters. Unknown to me is whether or not the house c...Being familiar with Michigan's weather conditions and how they impact a home's structure will be a plus. Your recommendations and solutions should effectively address and prevent any potential instability or damage. Please include any relevant experience, project estimates, and methodological approach in your bid. Completion timeline is flexible and can be negotiated based on your professional opinion and strategy. We value quality, precision...

...how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my project brings to the market and why it's a worthwhile investment. In terms of the length, I'm looking for something between 5-10 slides - it should be long enough to be comprehensive, but succinct enough to hold the attention of potential investors. Ideal candidates should have: - Proven experience in creating successful pitch decks that have secured fund...

...Mechanism Project Overview: We are seeking a skilled and detail-oriented freelance mechanical engineer or designer to work on a comprehensive mechanical design project. The project involves selecting an appropriate architecture for various linkages, creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of select...

...the local language, a mafia woman, etc. The possibilities are endless. 2. **Collaborative Storytelling**: - Every player online is roleplaying their own character. - Stories, plots, and actions are developed collaboratively, with everyone staying true to their roles and following the rules. 3. **Dedicated Servers**: - Roleplaying occurs on dedicated servers for the PC version of Grand Theft Auto V, as this mode is not available on consoles. The Project Vision: - **Recreate the GTA RP Experience in Minecraft**: - The goal is to build a Minecraft map that mirrors the GTA RP server's environment and dynamics. - This will involve detailed world-building to capture the essence and activities available in GTA's sandbox environment, translating t...

Pleas read the attached document

I want a strategy for tradingview that it opens the orders manually or crossing emas, we input a range for the stop loss and take profit using % or $ and when it reachs the SL it opens a new order using the same range and different direction, if it is long, turn in to a short but with the value increase by a pre set multiplier (one for the SL ad one for the TP) and also add a possibility to multiples TP We also need to pre set a limit of times that the reversion happens and also add a option tralling stop loss. Can you make it?

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

...expert who can help me optimize my video game site for search engines, focusing specifically on Google. My site is dedicated to selling virtual goods for Final Fantasy XI, and I'm looking to enhance visibility and draw in more potential customers. Key Responsibilities: - Conduct a thorough analysis of my website's current SEO situation, pinpointing areas for improvement. - Implement effective SEO strategies to boost my site's ranking on Google. - Optimize keywords and meta tags. - Rectify existing SEO errors, broken links, and other issues that might be hindering my site's visibility. The ideal candidate will have: - Proven experience in SEO, particularly with e-commerce sites. - Expertise in Google SEO strategies. - Strong knowle...

Monthly Seo Ongoing With weekly work reports and google ads for

...In input file 1 you need to filter the data in column B and take into consideration only "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Dettagli prodotto" of the input file 1 are present in column A of the VAT output file and we have a value in col...

I'm looking for an experienced domain broker to assist with selling a high-value domain in the technology industry. Key Points: - **Domain Expertise**: Familiarity with the technology niche is crucial. Understanding of the potential buyers and market, as well as the ability to articulate the domain's value. - **Negotiation Skills**: Proven ability to negotiate and secure high-value sales. Past experience in selling high-end domains would be a significant advantage. - **Professional Network**: A well-established network in the tech industry, particularly among potential domain buyers, would be highly beneficial. - **Confidentiality**: Ensuring all transactions are handled with the utmost discretion and confidentiality. I have a target price in mind higher t...

...environment - Opportunity to work on a variety of exciting projects - A supportive team that values your input and creativity If you are passionate about technology, constantly seeking to learn and improve your skill set, then you are the type of person we are looking for! We are offering superb career growth opportunities, great compensation and benefits. **Application Process:** 1. Submit your detailed resume/CV highlighting your relevant experience and recent projects. 2. Attach a concise cover letter, elaborating on your suitability for the role. 3. Provide links to any applicable portfolio pieces or code samples, with a preference for Github profile. 4. Detail your most recent projects where you extensively utilized React and TypeScript. 5. We value your tim...

I am looking for fre...Key Notes: - This is a commission-based role, and I intend to reward successful sales generously. - No website design or layout is required as the sale is purely for the domain names. - There are no specific keywords or phrases related to the domain names as they cover an extensive range of subjects. Ideal Candidate: - Knowledgeable about digital assets, particularly domain names - Proven sales experience, preferably in the digital marketplace - Highly persuasive and comfortable with cold outreach - A solid understanding of the value of domain names in today's market This isn't about creating websites. It's about selling potential scale, opportunities, and a vision to your audience. If you believe you can sell these domain names and m...

I'm in need of a proficient CSS Animation expert, comfortable with both vanilla JavaScript and React. Your task will involve incorporating specific animation effects into a project. Key Features: - Apply 'Fade in/out' and 'Rotate' animation component based on the value of the a sliding scale. - Work uniformly across both mobile and desktop devices. Ideal Skills: - Expertise in CSS and SVG animation - Familiarity with vanilla JavaScript and React - Strong understanding of responsive web design and development Flexibility in your use of vanilla JavaScript or React is preferred since I have no strict preference between the two. Anticipate demonstrating your ability to innovate and effectively apply your skills to create engaging user experience...

I'm looking for a skilled android developer to create a professional application for me. The app will be targeting professionals as the primary users. Key Features: - User Login and Registration: The application should allow users to create accounts and log in securely. - In-App Purchase Functiona...professional audience. Ideal Skills: - Proficiency in Android app development - Experience with in-app purchase integration - Ability to implement secure user login and registration systems - Prior work with push notification services - Strong design skills, especially in creating icons - Understanding target audience of professionals If you have additional expertise that you believe would add value to this project, please feel free to mention it in your bid. Looking forward to ...

I'm in need of a generative artificial intelligence that can analyze given text inputs and provide suggestions based on the analysis. The main purpose of this AI would be for data analysis. Key Requirements: - The AI should be primarily text-based. - It should be able to process and analyze the supplied text. - The output should be suggestions derived from the analysis. Ideal Skills and Experience: - Previous experience in developing generative AI systems. - Proficiency in natural language processing and data analysis. - Strong understanding of machine learning algorithms.

I need a general audience-focused, 800-1000 word article on club chair office furniture. The article should provide a comprehensive overview of the design, comfort, ergonomics, and durability of club chairs for office use. Key Points to Include: - Design and Aesthetics: Describe the aesthetic features of club chair office furniture and how they contribute to the overall appearance of an office space. - Comfort and Ergonomics: Highlight the comfort levels and ergonomic designs of club chairs, explaining how they can improve workplace productivity and employee satisfaction. - Durability and Quality: Emphasize the durability and quality standards of club chairs to ensure long-term use and value for money. - General Information: Provide general and informative content about clu...

Looking for a skilled developer to help with an issue related to Livewire gadgets. The key points of the project are: - The problem: Currently, the save functionality of one of the gadgets, namely Index Filter, is not working as intended. It's not saving data correctly. I need this to be fixed. -Also need to fix livewire library issues please Ideal candidates for this project should have: - Proven experience with Livewire gadgets - A strong understanding of database systems, particularly in the context of web applications - The ability to troubleshoot and solve issues efficiently - Strong communication skills to understand and implement the necessary changes to the saving mechanism.

I'm looking for a detailed and engaging article that introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words,...professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be professional and engaging, keeping the reader interested from start to finish. This piece should be well-researched, original, and truly showcase the value and importance of large conference tables in a workspace. Ideal Skills and Experience: - Strong research abilities - Excellent writing skills - Experience in content creation for furniture or office equipment ...

Upload application on google play console.

I require an adept senior-level Chartered Accountant/Chief Financial Officer (CFO). My ideal candidate will maintain responsibility for: - Rigorous financial reporting - Diligent budgeting and forecasting - Effect...budgeting and forecasting - Effective cash flow management -Supervision of existing staff to facilitate GAAP processes and timely monthly close processes A deep and demonstrated understanding of auto parts industries is non-negotiable. With your experience, you will add significant value to my company's financial standing and strategic growth. Proven track record in similar roles is highly valuable. You will be working remotely, using the data we provide and other data that you gather to advise our leadership team on all financial matters and the financial...

I'm seeking a skilled developer to create a versatile e-signing utility. This tool should allow users to select the DSC ( usb token) inserted to the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software ...

I'm doing the google ads setup and have a campaing already but it's not visible Need help through team viewer to set it up and see the clicks as I did earlier.

...annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on target. * Data validation for entry consistency: Ensuring that data is entered correctly, preventing errors. *Eligible to insert in google sheets with same formatting The ideal freelancer for this project should have: - Proficiency in Excel formulas and functions for tracking project progress. - Experience in creating automated Excel sheets using conditional formatting and data validation. - Attention to detail to ensure the accuracy and functionality of the sh...

I'm looking for a professional to perform a comprehensive SEO audit, with a focus on Google, for my website. The ideal candidate should have: - Strong expertise in SEO, particularly Google optimization - Experience in identifying and resolving technical SEO issues - Ability to work with minimal analytics and previous SEO reports Key objectives for this project: - Identify technical SEO issues: My website has been live for a while but is not getting any search traffic. I need a thorough review to pinpoint any underlying technical issues that may be hindering its search visibility. - Recommendations for improvement: Based on the findings, I would like actionable recommendations on how to improve the technical SEO of my website. If you have a...

I've created an Android app and n...seeking a skilled developer who has experience with Google Play Console to deploy this app for me. Key Project Requirements: - The app is ready for deployment, so the main task is publishing it on the Google Play Store. - The developer should have a deep understanding of Google's app deployment process and the ability to navigate the Google Play Console efficiently. Ideal Skills: - Proficient in Android app development and deployment. - Prior experience with Google Play Console. - A good understanding of app store policies and guidelines. - Strong communication skills to ensure a smooth deployment process. Please note that I currently don't need assistance with creating promotional materials for th...

I'm looking to create a comparison website to help potential traders assess and select proprietary trading firms in the finance industry. Key Requirements: - The site should have a comprehensive database of different proprietary trading firms, their key features, and offerings. - Users should be able to filter and compare the firms based on various criteria like trading strategies, capital requirements, and more. - A user-friendly interface and robust backend that can handle large amounts of data and provide real-time updates are crucial. Ideal Skills & Experience: - Web development experience, particularly in building comparison websites. - Understanding of finance and proprietary trading firms. - Proficiency in database management and user interface desig...

I need a skilled developer to create custom functionality for my WordPress site using JavaScript. This new feature will be integrated into a specific existing page on my website. I need a site, showing the villas and providing the same experience for visitors. This site has many villas and features, including filters, maps, and search functions. It has 120 villas. I need the search filters and map filter search the same as reference site. The site has a big map showing areas like North, West, etc. When you click on an area, it should display the villas in that region. If you can make a similar map feature, that would be great. Let me know if you can do this.

Project Title: Basic Audio Note ...accounts and login system Ability to upload audio files (3 seconds max) - MP3 format preferred Option to add simple labels (e.g., "Meeting Notes," "Quote") to each audio file Ability to sort and filter audio files by upload date or label Basic interface for browsing and listening to uploaded audio files Secure storage of user data (audio files and labels) Target Audience: This app caters to users who want a simple way to organize and access short audio snippets for personal use. Think of it as a basic audio version of a text-based note-taking app. Please Note: This is a very basic project focused solely on functionality. No need for fancy features like audio editing, playback speed control, or file sharing. Desi...

Hi, Looking for a person to create an spread sheet monthly for sales records during that month. Will need to take information off of individual sales order sheets/emails and transfer it onto a spread sheet... buyer/address/item(s) they bought/amount they paid etc. Will be a reoccurring task per month. Will pay per month, expecting 100-200 sales per month. Please show rate per entry.

I need assistance in integrating an automatically generated Order ID within my Google Forms. Many people do it so, AT THE END the form, it will generate an ID number that will go into the Google Sheet where the responses go. In this case, I need it to be in form of a Short Question INSIDE THE GOOGLE FORM, Not at the end. So this way, the number generated will be part of the info the client sunbmits like Name, Phone Number, Zip Code, etc. Please ask questions before agreeing to begin.