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

Forum Posts

Resolved! Recreate UNIQUE function

Hello! Im looking to recreate this function in Airtable=COUNTA(UNIQUE(Masterlist!C5:C))Where the column in Airtable I'm looking to count unique entries in is called CLIENT NAME. Unfortunately, it doesn't look like the UNIQUE function works, is there ...

ryanngp by 4 - Data Explorer
Solved
  • 263 Views
  • 3 replies
  • 3 kudos

Limiting Duplicate Text in Lookup Cells

Hello-I have a lookup cell that is pulling data from multiple cells. The results are showing a list of topics. The topics are repeated (as they're pulling from different cells). You can see, for example, that "Space" is being pulled multiple times. I...

LaurenMaine by 6 - Interface Innovator
  • 739 Views
  • 5 replies
  • 0 kudos

Google Drive Folders Synced to Record

I have a table that is creating a record for each client that completes a form. I have another table on the same base which is a synced google drive table with all client folders. Is there a formula/automation I can use to link the "open in google dr...

tahsinh by 4 - Data Explorer
  • 552 Views
  • 8 replies
  • 1 kudos

Resolved! Group by / Unique Values

Hi everyone,I am wondering if there is a workaround/solution without using make.com or scripting.I have data in one column for example. The column is a linked field.Items | Qty_to_BuyA|5A|1B|1B|1B|6C|10 I want to create a table with the following out...

aryan201215 by 4 - Data Explorer
Solved
  • 267 Views
  • 1 replies
  • 0 kudos

Resolved! Automatic duration calculator

I want to have a select field with a couple of options for clients that need a subscription. Like: "1 month subscription", "2 month subscription", ... . This would ideally convert the answer into a 31 day duration field that can then be used in a dat...

KoBla by 4 - Data Explorer
Solved
  • 300 Views
  • 3 replies
  • 2 kudos

Resolved! Exclude Duplicate/Repeating Values via Lookup or Rollup

Hi everyone! I have an Airtable base for a virtual event my team is planning for Learning at Work Week. The base includes the following:An "Activities" table with all of the activities that learners can complete, each worth a certain point value. The...

bredah by 4 - Data Explorer
Solved
  • 353 Views
  • 2 replies
  • 2 kudos

Resolved! Formula cell maodifies text

Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} n...

ARiios by 5 - Automation Enthusiast
Solved
  • 294 Views
  • 2 replies
  • 2 kudos

Resolved! Attachment URLS

I know I am late to the game here. I have been ignoring the updates until now. I currently have uploads and the links for the uploads through a formula - which allows me to create a download button.I use these so in the public share link to my base -...

Elizabeth_Aucti_0-1676346277967.png

Rollup fields, formulas, and nuances driving me nuts

Dear community of people so much smarter than me!I am using Airtable to build a film budget that has a number of fields and formulas that are causing me headaches. Table 1) Budget top sheet (two rollup fields: budget & actuals)Table 2) Budget (above ...

Formula If client is married, primary field will show spouses name.

I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be ...

tahsinh by 4 - Data Explorer
  • 441 Views
  • 1 replies
  • 0 kudos