I have a table created like the one on the picture and would like to create a concatenate field with the name of the columns that have stars associated with. Is it possible?For the first record the formula should return (M&A, IPO, Turn Around, Financ...
Winged Foot Condominium Assn dBase.Base has 2 Tables named Maint Fees and Winged Foot AssnMAINT FEES TABLEMaint Fees table has 5 fields: Unit Name > [$] 2022 Maint Fees > [$] 2023 Maint Fees > [Linked] Winged Foot Units > [A] NotesMaint Fees table ha...
Trying to accomplish this simple formula but it results in an error???Using a Single Select Field and a Currency Field.{Toe Kick LI} * {Toe Kick Cost Per LI} Thanks in advanced for your assistance!
I have the following FieldsTemplate Type (options are either TEXT Only or With Weblink)Title LineCopyName of LinkURL When user selects Template Type Text Only, I need a field that will display the full text and contents:{"iconName":"safety","text":"C...
Dear communityI need a formula to sum number rows. This seems a bit difficult, but maybe I'm just dumb...I just need to summarize #Beløb F and #Beløb S into #Beløb. I am doing it manually right now.Basically: #Beløb F + #Beløb S = f BeløbCan anybody ...
Hi everyone!I have two lookup fields, each one of them with a list of dates, and I need to merge them in the same field, keeping the date format. I've been testing with some formulas like concatenate, arrayjoin, dateformat... but I haven't been able ...
Hello, I am looking for a way to combine five fields (address, second address line, zip code and city) to a new multiline text field when another field "second zip code" has a value. So here is an example of the five fields: Address: 220 Miller Avenu...
Hi everybody I am new to airtable and trying to put a class scheduling together. I have mostly been using the template and learning through trial and error. Now I have produced a weird error that does not seem to impact the functionality but is very ...
Hey! I have 3 checkbox fields that indicate the completion of a task. I want to show completion of the tasks using the newly released progress bar on the Percent tab, but without having to manually type in the thirds (1/3, 2/3, 3/3). If I use a formu...
Hello everyone! I'm attempting to construct email and Slack automation to remind my team to update specific projects (records) in a project management interface. When we were in data mode, I merely included a link to the Record URL in the automation ...
Question on the following formula. I have tried just about anything and everything to get this formula field to only calculate the score based on after the date. The formula works perfectly fine without using any date fields. Form type (single choi...
Hello community! We use airtable as an ATS (applicant tracking system) and now would like to extend it to project management.I have 2 different tables: candidates and jobs. I now want to create a new task table (classical kanban project management) w...
is there a way of adding a joint array, concatenate to my primary field (containing Email and Full Name), but still be able to link to that table using email only. in other words, my contacts have different emails, and currently primary field is thei...
Hi, struggling to wrap my head around date formulas, thanks for your patience with all my questions!I'm trying to set up a formula field that will calculate the next due date for a submission based on when a record was submitted via a form. I have th...
Hi everyone,I've been searching airtable forums for hours yet I can't find a solution that clearly explains what I need to do to achieve my desired results. There are different answers talking about using MIN() or something other formula, but I can't...
Hi all,I'm sending out emails via Airtable and some (but not all) recipients are noticing a very weird problem. The URL code shows the markdown text instead of the URL link, ie., it shows [TEXT](url) instead of TEXT.I thought it might just be a probl...
Hi, I have a long text field with the info bellow and would like to extract the infos in bold to different field but cant find a formula to help me with. Thanks in advance for any help guys.This is the text I have in the long text field (its in portu...
In our scheduling table for projects (table is called "Deliverables"), we have 6 sequential dates that tend to move frequently:Kickoff DateCreative ConnectRound 1 to ClientRound 2 to ClientRound X to ClientDue DateI've been trying to write a formula ...
How to calculate the counts' fields if it is newly created in existing records that we have a formula for the attendance sheet.
Hello, all. I am importing a CSV file into Airtable. Some of the CSV data ends up as Long Text fields in Airtable, and consists of blocks of text with multiple paragraphs. It comes in with <p> and </p> indicating these paragraphs.In Airtable, the <p>...
| User | Count |
|---|---|
| 785 | |
| 759 | |
| 583 | |
| 472 | |
| 273 |
