I have a google sheet that I would like to generate a price based on different information on different tabs. I have uploaded an excel version of the sheet but the code needs to work in Google Sheets as this is the format of the live version.
There are sizes (column AJ and AK) to work out a square meter size. The minimum chargeable size is 0.3sqm so anything under this size needs to be charged at 0.3 minimum. Column H contains a product code of either "DGU" or "Single".
If DGU is selected then the input information is in columns AL:AQ using the corresponding prices on tab "sealed unit pricing".
If "Single" is selected then the input information is in Columns AR:AT using the corresponding prices on tab "Single sheet pricing".
Finally the line item total calculated from the above would be multiplied by the quantity in column J with the final price input into the column K.
Jewelry 3d sketch Category: 3D Animation, 3D CAD, 3D Design, 3D Graphic Design, 3D Illustration, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization, Product Design Budget: $10 - $150 USD
04-May-2026 16:00 GMT
Google Ads Lead Campaign Category: Advertising, Google Ads, Google Adwords, Keyword Research, Lead Generation Budget: €8 - €12 EUR
04-May-2026 16:00 GMT
Roblox Game Development Category: C, Programming, C++, Game Design, Java, Lua, Roblox, Simulation, Unity 3D Budget: $250 - $750 USD
04-May-2026 15:59 GMT
Build My Second Brain System Category: AI Chatbot, AI Development, AI Model Integration, Content Management System (CMS), Data Integration, Digital Strategy, Project Management, User Experience Research Budget: £10 - £15 GBP
04-May-2026 15:57 GMT
Sports Event Management Mobile App Category: Android, Database Management, Flutter, IPhone, Mobile App Development, PHP, React Native, RESTful API Budget: $250 - $750 USD
04-May-2026 15:53 GMT
Complete My Ecommerce Website Category: Backend Development, CSS, Frontend Development, HTML, JavaScript, Payment Gateway Integration, PHP, Web Development Budget: ₹1500 - ₹12500 INR
Google Form Custom Email Category: API Integration, Automation, Google Chrome, Google Sheets, HTML, JavaScript, PHP, Scripting Budget: $30 - $250 USD
04-May-2026 15:52 GMT
Textured Concrete Fence Column Category: 3D Animation, 3D Modelling, 3D Rendering, 3ds Max, Building Design, Building Engineering, Construction, Construction Management Budget: $250 - $750 USD