Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Set up linked record for variable costs

Topic Labels: Formulas
152 0
Showing results for 
Search instead for 
Did you mean: 

I have a base with labor rates, which can vary depending on retail / wholesale, etc … screenshot 1

Screen Shot 2022-04-08 at 3.52.06 PM

That table links to another table in the same base, which has a variety of categories. Might price category 1 at List Price, category 2 at 10% off, category 3 at cost +10%, etc … screenshot 2

Screen Shot 2022-04-08 at 3.53.29 PM

Is there a way to have one “base rate” amount, and then have the variable rates calculate based on that? Right now, I just input them each manually. Would be nice to change the “base rate” and have all the variables automatically update. I realize I could do this in multiple fields, but that won’t give me the ability to have a linked record selection?

Thanks in advance

0 Replies 0