Need Help with spices formula

hi everyone,
need help with spices formula I have (a, b, c,) spices and each one is 500g and each time a flavor count is up by one reduce (a) and (b) by 20 and so on…
if anyone can help me with this formula I will be thankful.

and thank you for your time.


More than happy to help. Can you restate your request in terms of your board and columns?

Thank you for your help.

For the columns.
Spice A | Spice B | Spice C | flavor count 1 | flavor count 2
500g | 500g | 500g | |

When (flavor count 1) is 1, 2,3…
reduce (Spice A) and (Spice B) by 20.

When (flavor count 2) is 1, 2,3…
reduce (Spice A) and (Spice C) by 50.

Thank you for your help.


I’m sorry it took me so long to get back to you.

I still don’t get exactly what you are wanting. I would need to know each of the column types. It seems like you are looking more for a transaction to change numeric column values and not an actual formula column.

To change numeric column values, there are 3 options:

  1. Use the General Caster app available in the marketplace.
  2. Implement a custom solution using Make/Integromat (or similar).
  3. Use a variation of this idea:

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Keep your Integromat scenarios from timing out! - YouTube
Contact me directly here: Contact – The Monday Man