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

Forum Posts

Sum by Group Value

Hello,I'm trying to create a schedule table to track team members availability each month using the total # of budgeted hours by month.E.g. for the month of May  If Sum of {Budgeted Hours} > 160 = "Overbooked" , = 160 "Fully Booked",  < 160 "Underboo...

cmhollis_0-1683207468787.png
cmhollis by 4 - Data Explorer
  • 480 Views
  • 1 replies
  • 0 kudos

Sum up COUNTIF across multiple tabs in a table.

Hi, I have this table in which each tab has a column with a checkmark ('Interested Lead'). I would like to sum up the total number of checkmarks in the 'Interested Lead" column across all the tabs in this table. 1). What should I use? a function? a r...

JDC_361 by 4 - Data Explorer
  • 1832 Views
  • 8 replies
  • 0 kudos

Rollup concatenate formula help

I have a rollup formula that returns a bullet pointed listed, which works beautifully (supplied by this incredible community - thanks!). I need to concatenate that with additional information though and am at a total loss.  This is my current output....

Screen Shot 2023-05-01 at 9.56.33 AM.png

Difference in attachment url

Hi, I have many rows with multiple attachments. Some attachment urls are having https://v5.airtableusercontent.com/v1/ format. Some of them have https://dl.airtable format.How do i tweak the script if possible to get https://dl.airtable format? I nee...

Display Options

Hi! I just moved over here from Quickbase. On QB, when I did a search, all the matching results appeared, and no other records were showing.In my new Airtable, my search results in a single highlighted instance of the matching search result, and I mu...

enhompe by 4 - Data Explorer
  • 461 Views
  • 1 replies
  • 1 kudos

Need help with Inventory table for my Short Term Rental.

Hello, I am using airtable to keep track of inventory for my Short Term Rental.I have an "Inventory" table + an "Update Inventory" table.When my cleaner is counting inventory in my STR she'll click on the "Update Inventory" button on my inventory tab...

rtlew by 4 - Data Explorer
  • 428 Views
  • 1 replies
  • 0 kudos

Resolved! Pull in values from another table based on date field

Hello amazing people! I am working on my film workspaces and trying to build a table to use for a Page Designer for a Call Sheet. I have several tabs I need to pull details from, all based on the Date Field. This Scenes tab is one of the places to pu...

Table 4.jpg Table 3.jpg

Check if value is added more than once per date

Hi everybody!I'm trying to move our Excel spreadsheet to Airtable to simplify things ans automate something.The spreadsheets is just a list of activity that we need to do (we rent stuff), have a look at the screenshot.Question: is there a way to tran...

24-03-2023_10-36-00_2_Logistica_partenza_CSV_5.csv_-_Excel.png
Peter39 by 4 - Data Explorer
  • 208 Views
  • 0 replies
  • 0 kudos

Creating a default message for a field if it's left empty

Hello! I'm creating an Airtable form, and I want to enable a default text to fill in a field if the field is left empty by whoever is filling the form. Example if name is not filled in, then it will default to anonymous instead of being blank. How do...

cbg by 5 - Automation Enthusiast
  • 874 Views
  • 4 replies
  • 2 kudos

Rollups: geting array values

I am trying to figure our how to use rollups. Let's assume I have a list of applicants and associated interviews. The interview has "interviewer name" field.Soapplicant1 -> (interview1; interview2)Interivew1: JohnInterview2: RebeccaI am creating a ro...

VictorN by 5 - Automation Enthusiast
  • 375 Views
  • 0 replies
  • 0 kudos

Converting Multiple Fields into Text Field

Hi all, I am looking to create a field that will automatically create a string from multiple sources.I am looking to create a bar schedule and I've found that the Gannt view is best for this as it allows me to export as a PDF. My issue is that I'd li...

Resolved! Rollup field to display date format of latest related date

I have created a Rollup field in my Contact table which searches within the Touch Points linked table and rolls up the 'Start Date/Time' field using the 'MAX(Values)' aggregation formula. My challenge is that I am unable to get a date which I can the...

Resolved! Lead Scoring by Calculating Multi Select Field Value Rollups

I am looking to score my leads in my Airtable which I use as a CRM. I have a multi select field called 'Journey' which has a number of events in the lead life cycle - for example an IOI (indicator of interest) of the prospect asking about the price, ...

Calculate total in list view of values in the level below

I am trying to use the new list view to create a system for putting together quotes for events. I have a list of event enquiries in table 1, and in table 2, have created a list view, where I am adding line items to events using levels. I would like t...

Manipulating Date data into the proper format

Hello,I have a web scraper that is pulling in assorted data from a list of projects. The issue being that the date/time data that it scrapes into my base doesn't convert very well into an actual date field type.Here is what I am working with:Any idea...

Screenshot 2023-02-07 at 11.35.35.png
Alec by 6 - Interface Innovator
  • 420 Views
  • 1 replies
  • 1 kudos

Hyperlinks

HelloIs there a way to include hyperlinks in a base? I am importing data from Excel, where I collected the profile of n individuals and for each profile I have general information (name, education, job title etc) and a link to their LinkedIn page. Wh...

federica by 4 - Data Explorer
  • 894 Views
  • 1 replies
  • 1 kudos

How many times a linked record has occured

I'd like to count how many linked records have occurred with another linked record. I have a table where each record is a contract between a company and a governmental entity. The company's column is a linked record and the entity's name is also a li...

Motlaq_AlMutair_1-1674915234669.png