Hi! I am using airtable to keep track of several types of info connected to individual clients. However, sometimes I need partners/spouses' names to be in the same column. Is there a way to write a formula that only runs when certain conditions are m...
Hi all–I have 'TABLE A' with a few fields that I'm getting an error for an hoping someone can show me my fault.I'm trying to get the cost per client for software we're using.RECORD A (Software)'CLIENT' (Formula Field that calculates # 'Users) Current...
Hi, this is a Voiceflow specific question, but I was hoping someone might have some ideas.I'm making an API call from Voiceflow using a multiple filterbyFormula to exclude words. This is what it looks like:https://api.airtable.com/v0/appname/tablenam...
I have a user groups as individual records. Each month, my team adds a field with the number of members in each group. This means I don't have a specific field i can put the 'latest' number in for more public views to the wider company. I am trying t...
I have a score card with a computed percentage grade (e.g., 84) that I want to turn into an easy letter grade for my stakeholders.Rather than using a huge nested IF formula I thought I'd try to use SWITCH to compare and create some values.SWITCH( {%...
I’m working on a project management system in Airtable, and I need to set up a counter system to assign unique numbers to tasks within a vertical hierarchy. The goal is to create a structured numbering system that reflects the task relationships and ...
Hello,I need help with figuring out how to lookup the right price of an item for a particular customer from a table.I have an order line item table that contains "Customer Name" and "Item Name". Using this information together I want to look up the p...
Okay i have a table that has input information that i have added formula to and get the desired results fields out of itresult fields are:Drawer Height, Side length, FB length, inner length, bottom width.note that each one of these fields has a value...
I'm struggling to figure out a good way to determine if a projects start and end date span any part of a specific year where start and end dates could span multiple years.So for example, I have records with the following columns for projects:Project ...
I have a base with records that consist of the URLs of several images inside my site's midia folder. They look something like:https://mysite.com/news/april/banner1.pnghttps://mysite.com/news/may/banner2.pnghttps://mysite.com/news/april/etc/week2/file...
| User | Count |
|---|---|
| 854 | |
| 823 | |
| 601 | |
| 517 | |
| 301 |
