Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Concatenate with Italic text

Hi All, I want to create a bibliography. I have all the pieces in different columns and want to use the concatenate formula to pull them all together. However the Title of the book needs to be in Italics, how do I carry over the italics from the cell...

Kathy_Lewis by 5 - Automation Enthusiast
  • 618 Views
  • 1 replies
  • 2 kudos

Lookups, Rollups, and Formulas producing comma after unique values

Hello,I'm pulling in purchase order data for my company, and have a "Vendor Management Team Partner" associated with each purchase order record.I'm also reconfiguring these POs in a separate table, such that the email address of the PO requester is t...

mtardiff_0-1709913200332.png
mtardiff by 5 - Automation Enthusiast
  • 269 Views
  • 5 replies
  • 2 kudos

Deduplicating names in a text array

Hi,I hope you can help me, I've searched everywhere and I can't find an answer to my problem.I work for a training organization. I have a table with students. A table with training session dates. And a table with speakers.In the dates table, I make a...

Resolved! Extract email from User Field

Is there a way to extract a users email address from their account info?Context...I have a form built in "interfaces" and have toggled on "see who submitted response".Ideally I'm trying to extract the domains for the users as a method to sort with di...

chrisberry by 6 - Interface Innovator
Solved
  • 169 Views
  • 2 replies
  • 1 kudos

Formula: dividing a column by a number

Hi, I’m trying to add a formula where I divide one column by a number. Like: Column A: 5000 Column B: result Formula: Column A(5000) / 365 Any idea? Been trying to find a solution to make this work…really don’t want to go back to excel… :sob: :frow...

Resolved! Converting word responses into intergers

Hi everyone, I am new to the Airtable and I'm excited to be part of this community. May I apologise in advance if I don't use the correct technical terminology.  I design surveys, impact assessments and evaluation tools for a criminal justice charity...

Resolved! Make.com formula for Airtable

Hi! I have data coming in from a webhook to Make. I am trying to create a formula in Make to search Airtable for number of times an email appears in a field on a table and limit the number of submissions to Airtable. For example, I want to limit the ...

lmac by 5 - Automation Enthusiast
Solved
  • 316 Views
  • 8 replies
  • 2 kudos

Statute of limitations countdown

Hello, I am setting a legal case tracking base and I am trying to do something where:1: When I input the date of incident, it automatically calculates two years from that date2: I would like to have a table that also has a countdown until we reach th...

Resolved! Using a formula to append strings

Is there a way to append data in a field? Let's say I have a long text field called "Campaigns" which will contain the different campaigns that a customer have agreed to through our emails. Is there a way to preserve the previous text and basically a...

JohnDoe by 5 - Automation Enthusiast
Solved
  • 141 Views
  • 1 replies
  • 0 kudos

Dates "sheet"? Update records based on one date

I want to create a "sheet" timetable that creates new dates using a formula based on one date that is inputted. I know there's probably a better way to say that so please disregard my ignorance. Here's what I want to happen...I input the "Class Start...

malloryjax by 4 - Data Explorer
  • 178 Views
  • 2 replies
  • 0 kudos

Resolved! Converting partial year and text to year/month

Hello! I have a large set of dates that are a partial year and month, and would like to convert this to a final date of the month format. Examples:Data I HaveDesired Format24-Apr2024-04-3024-Aug2024-08-3023-Dec2023-12-31I've tried concat using LEFT( ...

betteratuno by 4 - Data Explorer
Solved
  • 275 Views
  • 1 replies
  • 3 kudos

Resolved! Return multiple values from all columns which meet criteria

Hi all,I have formulated columns Apple, Orange, Banana, and the formula produces "Y" or "N" values. I want to create another column that will return the name of the column if their value is "Y". Is there any way to do this?I have tried nested IF form...

Screenshot 2024-02-26 at 4.02.13 PM.png
jen1392 by 4 - Data Explorer
Solved
  • 401 Views
  • 6 replies
  • 1 kudos

Limit data submission by user

I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?

lmac by 5 - Automation Enthusiast
  • 374 Views
  • 4 replies
  • 1 kudos

Rollup Max() Issue for Recent Date

I'm setting up an interface that will serve as a dashboard to show my time overall client financial info. I used rollups so all the data would be in one table which will allow people viewing the dashboard to only use on filter to filter by client. Th...

Resolved! Add Dates Automatically based on Word

If there are options in a drop down menu (example Quiz or Test), start dates are entered by user, can I add a new column with a formula that detects the word 'quiz' or 'test' in the previous column and add an end date automatically based on the word?...

JaclynB by 5 - Automation Enthusiast
Solved
  • 2374 Views
  • 7 replies
  • 2 kudos

Resolved! Help with a conditional formula

Can anyone tell me where I'm going wrong with this formula? SWITCH( {HS-LA %},"15%", ({GBP Amount}-{HS-LA Commission}),"10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission}),)Or suggest another way to achieve it - I've tried a few IF options too...

HannahS by 5 - Automation Enthusiast
Solved
  • 180 Views
  • 2 replies
  • 1 kudos

Formula to auto generate data in new cell

I am using Air Table to capture costs per garment style and there are 12 versions of the costs that are available to use based on importing tariffs and shipping modes. These 12 costs are hard keyed into the base. I would like to be able to make the c...

amoersen by 4 - Data Explorer
  • 195 Views
  • 1 replies
  • 0 kudos