Help

Re: Formula to auto generate data in new cell

664 0
cancel
Showing results for 
Search instead for 
Did you mean: 
amoersen
4 - Data Explorer
4 - Data Explorer

I am using Air Table to capture costs per garment style and there are 12 versions of the costs that are available to use based on importing tariffs and shipping modes. These 12 costs are hard keyed into the base. I would like to be able to make the choice on a tariff rate and a ship mode and have the cost autopopulate into a new cell so I can link this elsewhere in my base. Is there a formula that could be used? 

1 Reply 1

Hmm, if this example makes sense:
 - User selects Proto LDP 7.5%, so an additional 7.5% charge gets applied
 - User selects, so an additional 25% charge gets applied

Then you could try using a SWITCH formula for this:

Value *
SWITCH(
  Type,
  "Proto LDP 7.5%", 1.075,
  "Proto LDP 25%", 1.25
)

Screenshot 2024-03-07 at 10.06.20 AM.png

I'm not entirely sure what your business logic is, but you should be able to use SWITCH to handle what you need!