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.
Field Recruiters for AI Data Infrastructure Company Category: Business Development, Data Collection, Digital Marketing, Influencer Marketing, Lead Generation, Market Research, Project Management, Recruitment, Sales, Social Media Marketing Budget: $2 - $8 USD
27-May-2026 22:00 GMT
TikTok-Optimized Mobile App Ad Creation Category: Advertisement Design, Banner Design, Graphic Design, Photoshop, TikTok, Video Ads, Video Editing Budget: $30 - $250 USD
27-May-2026 21:57 GMT
Automate Sheets Sales Dashboard Category: Data Analysis, Data Management, Data Processing, Data Visualization, Excel, Google Sheets, Inventory Management, Scripting, Visual Basic, Visual Basic For Apps Budget: €250 - €750 EUR
27-May-2026 21:57 GMT
Přesný 3D model bytu (např. SketchUp) Category: 3D Animation, 3D Architecture, 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, SketchUp Budget: €250 - €750 EUR
Prototype Game Development: Puzzle & Exploration Category: 3D Animation, 3D Modelling, Blender, Game Design, Game Development, Game UI, Lighting Design, Unity, Unity 3D, Unreal Engine Budget: €30 - €250 EUR
27-May-2026 21:53 GMT
3D model třípokojového bytu Category: 3D Animation, 3D Architecture, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Interior Design, SketchUp Budget: €250 - €750 EUR
DTC UGC Ad Video Editing Category: Adobe Premiere Pro, After Effects, Animation, CapCut, Final Cut Pro, Motion Graphics, Video Editing, Video Production Budget: ₹12500 - ₹37500 INR
Agentic AI Personal Assistant Build Category: Agentic AI, AI Agents, AI Chatbot Development, AI Development, Claude (Anthropic), Claude Code, OpenClaw Budget: Fixed Price — up to $1
