Forum Discussion
Display the amount ( value K€ ) according to several criteria
Hello to all,
I would like to find the formula that based on the quotes I would add in spreadsheet 1 ( 2nd chart ) will automatically enter the value ( amount ) in spreadsheet 2 ( 1st chart ) following these criteria please :
- Type : Elec or AC or Masonry or Plumbing and...
- Category : 'Gros oeuvre" in blue
-> All defined by Hub ( Wh ).
I hope I was clear enough in my wording.
Thank you in advance for your valuable help.
Kind regards, and have a nice day
See attached file. I hope this is what you are looking for.
5 Replies
See attached file. Maybe this is what you are looking for.
- Thanks for your feedback OliverScheurich.
Unfortunately, it doesn't answer my request.
If we take for criterion column Type ( Elec or Plumbing or Air Conditioning or Mansory, etc... and column category "Gros oeuvre" only associated ( table 2 ), display the amount that will be entered directly in table 1.
Ex :
Table 2 :
Hub: mpl-chaptal; Type = Elec; Category = Gros oeuvre ; Amount = 4
Auto result table 1 :
At the intersection of mpl-chaptal and electricty, let the value 4 from above be returned and so on for each Type as soon as the category "Gros oeuvre" is chosen.
I don't know if I am clearer this waySee attached file. I hope this is what you are looking for.
Does anyone have any insights please?
I've tried a lot of things, but not being very familiar with the tool, I'm stuck...
Thanks in advance 😉
