Selecting Price based on Single Select Column

[Papabean]

Hello!

Excuse me if there is an easy solution for this.

I would like to be able to auto-populate my “price for ad” field based on my single select column “ad size.”

There are 31 different selections and 31 different prices. Do I need to write a formula for each selection and the price, or is there an easier way to accomplish this?

The formula that I am trying is:

IF({Ad Size}=“10x10 PBPost”,1108.50)

I’m having no trouble with the formula running, but it is not returning any values to the formula column.

[augmented · Accepted solution]

Hi Brandon. The most “maintainable” way to accomplish your goal is to create another table (with Ad Size as the primary field) and link to it (will change your single select to Link field) in your current table. This other table will have a price field (at least) which you can then bring into your current table as a lookup field. Then, changing price is as easy as editing it in your ad price table - no ginormous formula to maintain.

Good luck!

[Papabean]

Wow…thank you so much. Exactly what I was looking for. I really appreciate it!