Google Sheets Jobs

Help with creating some Sheets & Dashboards on google sheets. Nothing overly complex. Potentially couple of tasks

A script to launch a new browser window based on a web adress informed by the selection of two existing drop down menu selections in my Google Sheet. Any one of three particlular words selected in the first drop down menu will default to a fourth word input to the web adress. Below is the format of the web adress and attached is an image of my existing Sheet console

Need someone to review current business operations, identify a streamlined process, suggest, develop and implement tools to track and report leads.

We want to create a attendance system for our office employees . They should be able to scan a code and mark the attendance . The Check In & Check Out Time with the Geo Location should be noted in Google Sheets .

We are looking to bring the following data into Google Sheets via Amazon's API's: 1. Our current selling price of the ASIN/SKU 2. Number of our sales in the past 7 and 30 days of the ASIN/SKU 3. Current BuyBox Price of ASIN/SKU 4. Current Lowest Price of ASIN/SKU (include shipping fees if it’s FBM and not free shipping) 5. Does the ASIN have a BuyBox or Not of ASIN/SKU? 6. Current FBA fees of ASIN/SKU 7. Number of FBA sellers within 3% of BuyBox price of ASIN/SKU 8. Current BSR of ASIN/SKU 9. 90 Day Average BSR of ASIN/SKU 10. Is Amazon listed as a seller of the ASIN/SKU 11. Amount of inventory that is Inbound of the ASIN/SKU 12. Amount of inventory that’s checked in and available at Amazon of ASIN/SKU 13. Amount of inventory that’s moving between warehouses at...

Looking for help with some pretty specific conditional formatting for Google Sheets. Not sure if what I want to do is possible, but I have to think there is a way to accomplish it. Thanks much

Our inventory contains raw materials of bulk seed and empty packets. We track our filled packets, which gives us the amount of bulk seed and packets left after filling, and we also have the ability to check in new bulk seed and packets as they arrive - both of these functions are done through Google Form entries with barcode scanners. We would like to add a function that removes the filled packets as we send them into inventory. We sell many of our individual packets of seed in "Collections", so we need to figure out a way to lookup all individual SKUs in a Collection and remove the entered quantity from each individual SKU.

I need an addon / extension for google sheets to assign custom or different user rights for each cell or row / column. For eg I have a sheet of stock / inventory with columns - Product name, Quantity, Cost, Sale Price. Suppose I have 20 people on staff. I want to share that sheet with all of them but with different user rights for different people. Senior managers may view & edit all columns while sales managers may see all except Cost column but cannot edit any column except Sale Price. Similarly all other staff may only see Product name & Sale Price and edit none. (see attachment for a screenshot of this file) I can restrict editing with protect sheet & ranges option but how can I restrict viewing of certain cells ? Also I want to restrict editing & viewing of many cel...

I need an addon / extension for google sheets to assign custom or different user rights for each cell or row / column. For eg I have a sheet of stock / inventory with columns - Product name, Quantity, Cost, Sale Price. Suppose I have 20 people on staff. I want to share that sheet with all of them but with different user rights for different people. Senior managers may view & edit all columns while sales managers may see all except Cost column but cannot edit any column except Sale Price. Similarly all other staff may only see Product name & Sale Price and edit none. (see attachment for a screenshot of this file) I can restrict editing with protect sheet & ranges option but how can I restrict viewing of certain cells ? Also I want to restrict editing & viewing of many cel...

We have three rental properties that we rent seasonally (mostly just during the summer) and we need put all of our 2021 expenses into Google sheets. Need help with creating the spreadsheets, and adding the data.

Needed to design documents, forms and tables in Microsoft / Google suite with emphasis on Microsoft forms and Google / excel spreadsheets. Preferred Qualifications Expert with Google docs, Google sheets, Microsoft Office. Experience with virtual assessment is an asset. MOS certifications from 2010 or after at Core level in Access, Excel, PowerPoint and Word preferred. Expert at Microsoft forms and data analysis. Experience using technology for online teaching and assessment is an asset.