Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 17, 2020 10:12 AM
I need to write a formula that tracks our uniform distribution and cost. Here’s what it needs to say:
We have 6 types of shirts:
Hat: $17
I need a formula that tells me based on the type of shirt they have * the qty based on the cost of the shirt what the total comes to.
Let me know if you are able to write this and if you need any additonal information.
Solved! Go to Solution.
May 17, 2020 12:19 PM
Hi @Joseph_James, I am available for hire as an Airtable consultant & programmer to do that. My full-time job is a professional Airtable trainer, Airtable consultant, and Airtable programmer. Feel free to send me a private message to discuss more. :slightly_smiling_face:
May 17, 2020 10:41 AM
This is probably not the best way to setup your system. You would probably want your items to be listed as individual records in another table with prices associated with each item, so you could lookup their values into your current table.
However, if you still want to do this with a formula, you would use the SWITCH function to result in the price based on the shirt name.
For example, here’s what part of your formula would look like:
SWITCH(
{Shirt Name},
"Newbie Shirt", 18,
"Gorilla Gang Shirt", 26,
"Rooster Shirt", 26
)
However, since most of your t-shirts are the exact same price, you will probably just want to make that value the default value, like this:
SWITCH(
{Shirt Name},
"Newbie Shirt", 18,
26
)
May 17, 2020 11:57 AM
Would you be willing to do a screen share with me and show me how to set this up?
May 17, 2020 12:19 PM
Hi @Joseph_James, I am available for hire as an Airtable consultant & programmer to do that. My full-time job is a professional Airtable trainer, Airtable consultant, and Airtable programmer. Feel free to send me a private message to discuss more. :slightly_smiling_face:
May 17, 2020 12:30 PM
I have no idea if im DMing you on this platform. I would be happy to hire you to set up my table the way i need.
May 17, 2020 12:53 PM
Hi @Joseph_James, I just sent you a private message!