I need to make my Google Sheets Spreadsheet automated
- or -
Post a project like this985
£10(approx. $13)
- Posted:
- Proposals: 7
- Remote
- #3340939
- Awarded
Senior Developer / Solution Architect / Database Expert / System Integration specialist
Colombo
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
Jhelum
⭐⭐⭐⭐⭐Web Developer : HTML : JAVASCRIPT : CSS : JQUERY : PHP : WORDPRESS : JOOMLA : ANIMATION : GAMES : AJAX : JSON : GOOGLE : API
Kingston
1742586227480426277542782977567138057734086016234
Description
Experience Level: Entry
Estimated project duration: 1 day or less
Hi,
I need these features added to my Google Sheets spreadsheet:
1) I need the 'CODES USED' section (bottom right) to update every time I add a new code into the F column
2) I need the PROFIT column (K) to be automatically calculated by doing the (revenue - fees - product cost - shipping cost) on its row
3) On the 'WHERE' column (E), I need to make it so that the row (B-L) changes to the correct colour when a word is inputted. E.g. when 'shopify' is inputted it changes to blue, 'amazon' orange, 'etsy' yellow
Please start your message off with 'Sheets' so I know you've understood the job.
The spreadsheet for reference is below (I have just put random data in for now):
https://docs.google.com/spreadsheets/d/1CXZtNS1HSLv_QXhO9O4WXbOaXHL8-BHvVCGpV3H-zx8/edit?usp=sharing
Lucy
I need these features added to my Google Sheets spreadsheet:
1) I need the 'CODES USED' section (bottom right) to update every time I add a new code into the F column
2) I need the PROFIT column (K) to be automatically calculated by doing the (revenue - fees - product cost - shipping cost) on its row
3) On the 'WHERE' column (E), I need to make it so that the row (B-L) changes to the correct colour when a word is inputted. E.g. when 'shopify' is inputted it changes to blue, 'amazon' orange, 'etsy' yellow
Please start your message off with 'Sheets' so I know you've understood the job.
The spreadsheet for reference is below (I have just put random data in for now):
https://docs.google.com/spreadsheets/d/1CXZtNS1HSLv_QXhO9O4WXbOaXHL8-BHvVCGpV3H-zx8/edit?usp=sharing
Lucy
Lucy B.
100% (7)Projects Completed
7
Freelancers worked with
7
Projects awarded
11%
Last project
18 Oct 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies