- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Newbie Shirt ($18)
- Gorilla Gang Shirt $26
- Macaw Shirt $26
- Rooster Shirt $26
- Champion Shirt $26
- Executive Shirt $26
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 17, 2020 12:53 PM
Hi @Joseph_James, I just sent you a private message!
