Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Multi-Variable Formula for Calculating Attribution of a Sale

Hello Airtable friends.I have a somewhat simple formulaic excel sheet that becomes very complicated when breaking it up to be used in Airtable.The goal:Based on the type of sale, each of 6 static 'sale stages' should have defaul percentage (out of 10...

Unique filter

I have read a few discussions on Unique filter - lookup then roll up. But i really can't seem to figure it out. I have my calendar synced - then I have a column of attendees, which is linked to companies. So each row has the different company in the ...

Selimafifi by 4 - Data Explorer
  • 2 replies
  • 0 kudos

Help with Switch formula based on Checkbox field

Can I use the switch formula to choose between the values of two fields based on whether a checkbox field is checked? I have 3 relevant fields in this table:{Contract Amount (distinct)} - a simple currency field showing the amount for this distinct r...

Splitting out values from multiple linked records

Hi everyone,I’m looking to incorporate the tracking of SLA’s into our base to measure performance against timestamps. Currently I have a table of all our SLA’s with descriptions and numeric values for the SLA which will be used in the calculation. We...

Adding certain statuses

Hello Community! I need some guidance... I have a few columns with fields that are Single Select and one of the options is "COMPLETED". I am looking for a way to create a formula for it to add "how many COMPLETED fields" I have for that record... For...

Mike_Lopez by 4 - Data Explorer
  • 3 replies
  • 0 kudos

please help, urgen

hi i need to copy the formula of the data "campagna" column of the database section in the "candidature" section so the data will appear even in this column. How can i do? I can't find a solution, thank you very much for the help. Please let me know

tommaso by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Finding the closest date in the future from a look up field

Hello all, This is my first time posting here! Apologies if the explanation is not the most succinct. I need help with creating a formula to work within an intricate email and list management system I've set up. I have two tables: Email --> Each reco...

erikdohner by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Need help with a formula lookup/rollup

Hi, I have 2 tables: Table 1 has a list of contractors and a field showing the value of the projects they've gotten. On Table 2 I have a field showing the contractor with the max value that auto updates as other contractors acquire projects with high...

Noochy12 by 5 - Automation Enthusiast
  • 7 replies
  • 0 kudos

Resolved! Convert a Comma Array into Linked Records

I have customers purchase information. in I'm able to store all of the customer's purchase information into a Long Text Field that looks like such:37466774995108, 37466777616548, 43650268266737, 37466778697892, 37466778632356, 43650344222961...

Link Record Example.gif

Resolved! Multiple Select Formula to return 'pending' subscriptions calculation?

Hello Airtable community!Hoping someone can assist with this formula conundrum. In short, seeking to calculate 'pending' (sold but not yet activated) subscriptions within an Airtable base. Subscriptions Table primary field is per nominated subscriber...

Gruss by 6 - Interface Innovator
  • 8 replies
  • 1 kudos

Resolved! Create URL for filtered Gantt view?

Hi, I'm trying to create a formula that will direct to a Gantt view filtered by a ProjectID field (So I can create a "Open Gantt Chart" button in an Interface using the "go to url in record" action that will open a Gantt view filtered by a specific p...

Liz_Shaw by 5 - Automation Enthusiast
  • 4 replies
  • 3 kudos

Resolved! Date Automation/formula

We have multiple dates that we need to have automatically update for us in table.Example:Move-in date (4/1/23) plus policy day (60) = Lease end dateLease end date - NTV date (30) + 5 days= NTV date needArrival Instructions date = 2 days prior to Move...

AmandaC1121 by 5 - Automation Enthusiast
  • 1 replies
  • 1 kudos

Embed Formula Link or attachment

the circled part is the focus… let take for instanceIf the "display attachment field" is not empty and the "cloud hosted field" is empty, a formula to display the display attachment field and not the cloud link fieldIf the "display attachment field" ...

Sched_kode by 5 - Automation Enthusiast
  • 4 replies
  • 0 kudos