The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I use the software to keep track of all my craft projects as well as all my supplies. I am trying to calculate the price of the supplies used for my projects ("cost per item * # of items" kind of thing), but one of my fields has multiple values. When...
Hello, I am new to Airtable and formulas. My current formula is thisIF({Full/Part Time}="Part-time", 0.5, IF({Full/Part Time}="Full-time", 1.0, 0))I want to add a condition that if another field has two selected clients, the part time value of 0.5 wi...
I have a table for payment processing. When new records get created with a certain status, I would like to find the biggest check number in the table and add 1. Not sure if this would be using automation or formulas but thought I would start here. Th...
Hello Airtable community!I inherited a pretty robust Airtable system from a predecessor and have been working to revamp it, but my formula skills are not as good as the person who came before me, and I've been struggling to get IF AND statements to w...
Hi there! I am trying to remove NaN values from a formula field where both positive and negative values exist. This is in an effort to clean up two extensions: One chart indicating the number of each value's occurrence and one number where I am tryin...
Hi,I'm trying to create a table to track income and the records feed from different tables using automations which are assigned a deal type as they're created. If they're type A the commission is 15% of the payment amount, if they're type B the commi...
Hi there,I'm looking for a formula to automatically calculate the Venue and Producer split of the Budget and Budget Committed as per the "Deal." However, at present, the "Deal" field is a text entry, and I wondered what the best way to achieve this i...
Hi There, I know I should already know this but I always get nervous when dates are involved. I want to be able to highlight either a field or a row when a task in the row passes the deadline. I don't need to know any other information like how many ...
I'm new to Airtable formulas, so I would appreciate your input.I created a formula that I absolutely KNOW was working. But suddenly the field where the calculation was says #ERROR! now although it said 100% before. I can't figure out what has changed...
I am trying to create a formula that will take the latest date from a linked field (Appointments) and enter the latest date in a new field called "Last Appointment." I tried to generate a formula using the AI which gave me this formula:DATESTR(ARRAYS...
| User | Count |
|---|---|
| 911 | |
| 838 | |
| 611 | |
| 556 | |
| 390 |
