The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
I'm having a really hard time with making a formula field only calculate a value if the input field is not empty, including if it's 0. For some reason Airtable seems to treat 0 and empty value that same.Here is my current formula: IF({Monthly Actual}...
Hi there. I'm trying to create a formula that returns a numerical value (price) based on a dropdown field. So, if "Option Zebra" is selected in the dropdown, the formula returns a value of 250. If "Option Lion", then the formula returns a value of 30...
I have a table of books with the following columnsBook Titleyear publishedAmazon LinkBookshop.org LinkI want to create a field that returns Book Title (Year Published) Amazon Bookshop, where the "Amazon" is linked abd "Bookshop.org" is linked.Is it p...
Hello Airtable Community!I'm facing a challenge with constructing a filterByFormula and came across a similar issue discussed here: https://community.airtable.com/t5/formulas/formula-with-multiple-values/td-p/174768.I have a column named Klasse, whic...
Hey there,Thank you for your time helping me !So i'm a mushroom farmer. I cultivate different batchs simultaneously. Each time I harvest one, I create a record for it, with the date of harvest, the batch harvested and the weight harvested. There is a...
I’ve been using Airtable for a while now, and while it’s a fantastic tool for organizing data and streamlining workflows, I’ve been contemplating how I can enhance my note-taking system using Airtable formulas. My idea revolves around integrating a s...
Hi, we receive form emails in our airtable base. what's the best regex to use to extract information?Email looks like this:*Your Name* Jane Doe*Organization* Best Company*Your Job Title* Sales Manager Thank you!
Hi all! I am trying to find a method to tell me the Field Name of the last modified field, using a Formula. Is this possible without external scripting? I'd also settle for Field ID, although not most ideal Was hoping for a function like LAST_MODIFIE...
I need a formula to verify a single-line text field only contains productId's separated by commas with <=30 comma separated productId's.OK: <=30 comma separated 8-character productIdsNot OK: >30 productId's; <8 or >8 character productId's, not comma ...
Hi there,I have a team of account executives and I'm trying to rollup the amount of revenue each person manages during a 12-month period. Revenue is generated on a per project basis. Each project has a start and end date and a monthly retainer fee, w...
| User | Count |
|---|---|
| 908 | |
| 837 | |
| 611 | |
| 556 | |
| 389 |
