Multiply a value from One Table to another

Showcase
1

Hi
I’m new to Coda and trying coz I’m useless at spreadsheets. I need to know how to write the attached as a formula.

Coda Formula Query
Coda Formula Query2346×2043 283 KB

Thanks
Mike

2

Hi @Michael_Brits
and welcome to Coda Community :handshake:

It is always easier if you can share your doc (you can embed it in your post by selecting Share-> Embed and giving permission to edit).

Anyway, formula in the Estimate.Price per column should be:
thisRow.[Repair Type].[Price per] * thisRow.Repairs

Let me know if it helps.
Cheers

3

You’re a star. Thank you. What if I wanted to choose several items from the drop down. Say I had plastic and aluminium repairs for the same item.

Hope I got the embed right
4

Hi @Michael_Brits,
almost… you should give permissions to the doc as well. :wink:

Thanks!

5

Hi

I have shared the link. I have expanded the table somewhat. This is damn hard for a novice but Coda seems to be what I’m looking for, for 20 years for my little business.

This is what I’ve got on Google sheets that I’m trying to achieve in Coda. I am asking a lot so if need be you can point me in another direction.

I also searched the net and cannot see how to reference a table in another sheet in a formula.

https://docs.google.com/spreadsheets/d/1y_coywpgcBf6xefeyiWzA3Ku81GkjC5PYIM3yJyO4og/edit?usp=sharing

Thanks

Mike

6

Hi @Michael_Brits,

Ok: tell me exactly what you need to do (also directly within the doc)

7

Hi
Thank you for your help. I really appreciate it. I have made notes on the sub page Estimate.

Thanks

Mike