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

Forum Posts

Resolved! Formula within automation

Hi - I am trying to update a forecast in case the field hasn't been updated for over a month. The idea is that if there are no updates, the forecast would lower by 10%. It all looks great, until I have to "Update record", I pull the record ID (dynami...

Resolved! Phone Number to Plain Text Formula

Hello, I think I need a help of Airtable community even though there is built in AI helper in the formula field. Here is what I am trying to do and have no success for some unknown for me reason. I'm creating an automation that with the click of the ...

bedjik by 6 - Interface Innovator
Solved
  • 349 Views
  • 2 replies
  • 1 kudos

Resolved! Count unique values in a column

I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and i...

Lisa_Wetherby_0-1712696136417.png
Lisa_Wetherby by 6 - Interface Innovator
Solved
  • 673 Views
  • 4 replies
  • 5 kudos

Resolved! Setting specific formula based on Driver Field

Hello Everyone,I am having a hard time with a specific formula. I want to set a formula that will calculate a certain percentage based on what driver is selected in the driver field. Example: for the Dispatch % field i need a formula that will go lik...

Screenshot 2024-04-09 084718.png
mike060410 by 4 - Data Explorer
Solved
  • 358 Views
  • 2 replies
  • 2 kudos

item-wise calculation/sum/multiplication of arrays of numbers

is it there is a way, preferably with formula/s, to perform element-wise multiplication of two arrays of numbers?For example, if I have two fields with arrays [1, 2, 3] and [4, 5, 6] respectively, can I write a formula that produces [4, 10, 18]?_I wo...

atusr by 7 - App Architect
  • 294 Views
  • 1 replies
  • 0 kudos

Output Markdown from field data using formula

Hello,I've been using a very hacky method of generating a Markdown table using a formula in my base. The below example uses Markdown in quotes for the table structure, and then pulls from field data to populate the table.Example: " # DIVINATION " & "...

Gwyllgi by 4 - Data Explorer
  • 284 Views
  • 0 replies
  • 0 kudos

Hardest Problem I've Ever Encountered

Okay guys, got a doozie... Basically, in the screenshot I have a table, which is the main table that 99% of things sprout off from. We have customers, who through a webflow form are able to select accessories to add on to their purchase. That gets re...

GolfCartsUSA by 5 - Automation Enthusiast
  • 1288 Views
  • 8 replies
  • 0 kudos