Hi, I have a doubt. I have a huge budget table and to work different scenarios to buy computers, but I can’t realize an easy way to multiply groups (amount of computers) instead of multiplying each row (very low effective).
Any ideas?
Hey there @Cristian_Alejandro_Reynaga ! Welcome to Coda!
I was a little confused from your post understanding exactly what you need - but if I understand you correctly, it would be best to turn your “Item” column into a lookup and store the quantity in that table.
Once you do that, your quantity column is a formula referencing the lookup table and you can increase that in a couple of different ways.
This GIF gives a few ideas! If its not what you are looking for reach back out, happy to help.
2 Likes
Hello Scott, thank you so much for your time and creativity!
I tried the idea and works perfect but…is there a way to mix in budget tables items available in auxiliary table (such as Computers table) and more simpler items like, for example, a router that does not need modifications and it is useless to adding it on Computer table? because this path will force me to duplicate all the items (I’m working on a table with 200 items).
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.