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

Forum Posts

Create a list using a Lookup field with prefixed numbers

I am currently trying to format information for later use, and need to keep to a pretty strict format, as seen in the first photo below. The inclusion of P1, P2.... is necessary to differentiate between information that has been provided to us and wh...

Bfroger_2-1690461416461.png Bfroger_0-1690461230434.png
Bfroger by 4 - Data Explorer
  • 523 Views
  • 3 replies
  • 0 kudos

Resolved! Bug with the concatenation of percent

Hi all !I've a concatenation formula wich works fine with all number but the 7%...That's crazy.... When I put 7% somewhere my formula return 7.0000000000001%... My fields are all in percent (precision 1%) but the concatenation field is in text format...

Nocode34130 by 5 - Automation Enthusiast
Solved
  • 438 Views
  • 2 replies
  • 2 kudos

Formula to work out business hours between two date fields

Hi guys,I have 2 columns in Grid view, each with date and time. One is a "Created" column, the other is a "Resolved" column.I am wanting to have a formula to put into a 3rd column / field to work out the business hours between the two other fields. H...

Untitled Base_ Table 1 - Airtable and 3 more pages.png
CameronG by 5 - Automation Enthusiast
  • 403 Views
  • 0 replies
  • 1 kudos

Creating an RFI register

Hi all,Very new to Airtable, needing some help setting up a template.I've attached a screenshot for reference.I am wanting to use Airtable to keep an RFI (request for information) log which can be shared with my clients on a "base" by "base" basis. I...

CameronG by 5 - Automation Enthusiast
  • 1128 Views
  • 7 replies
  • 0 kudos

Rollup over three tables (inventory, recipes and production mix)

I've been banging my head on this one for a while so any outside ideas would be more than welcome!We have three tables.Inventory: contains list of materials and their initial amounts. Each material is treated as a batch material so once it runs out, ...

Tuxie by 5 - Automation Enthusiast
  • 563 Views
  • 4 replies
  • 0 kudos

Resolved! Add new text from one cell to an ongoing list in another

Hi everyone,I'm trying to solve a workflow/formula problem I've run into.Goal: I am building a task tracker, and it's important we have a history of steps already completed for each task. I have built a table that lists the tasks, and one of the colu...

Jade_Payne by 4 - Data Explorer
Solved
  • 431 Views
  • 1 replies
  • 1 kudos

Resolved! Simplifying Data Entry: Defaulting and Editing Fields in Airtable

I have fields for "First Name" and "Preferred Name." I want the "Preferred Name" field to default to the value in "First Name," but still be editable if a different preferred name is desired. I also want to implement a similar approach for the mailin...

Tracking inventory when usage is calculated

I an Airtable newbie. I work at a public library and use Airtable to manage and track our booklists. Since there are no sales or orders per se, we calculate usage using physical counts. Every few weeks I count them and record in Airtable the current ...

Finding most recent date across linked table

Hi all,As a new AirTable user, I am seeking assistance in creating a base to support my father's nonprofit organization in managing data. Currently, I have two relevant tables: 1) "Foundations Records" which contains information on grant agreements a...

Benrobot26 by 4 - Data Explorer
  • 835 Views
  • 4 replies
  • 1 kudos

Resolved! Formula with 0 value within IF statement

I have this working formula to return 'Reaction Hours'...ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2) If the request and reaction times are equal, 0.00 will be returned (correctly).  But then I embed it in an IF st...

DanielP by 6 - Interface Innovator
Solved
  • 546 Views
  • 2 replies
  • 1 kudos

Resolved! Formula to return multiple values

I have data that essentially looks like this:I want to use a formula to populate the last column with the type (in my example, food) based on whether or not other cells in the row are greater than 0. So IF (column A, B or C is >0, return "Fruit") AND...

Screen Shot 2023-06-21 at 11.37.20 AM.png
lcar by 5 - Automation Enthusiast
Solved
  • 809 Views
  • 4 replies
  • 2 kudos

Resolved! Change a Lookup field to a Formula field?

Winged Foot Condominium Assn dBase.Base has 2 Tables named Maint Fees and Winged Foot AssnMAINT FEES TABLEMaint Fees table has 5 fields: Unit Name > [$] 2022 Maint Fees > [$] 2023 Maint Fees > [Linked] Winged Foot Units > [A] NotesMaint Fees table ha...

Tom_David by 6 - Interface Innovator
Solved
  • 765 Views
  • 3 replies
  • 0 kudos

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...

Jack_Skinner by 5 - Automation Enthusiast
  • 876 Views
  • 5 replies
  • 3 kudos

Rollup from Multiselect - Expense Calculator

I am trying to create a tracker for trip expenses. I have a list of Attendees in one table, then Receipts in another with a "Charge To" field (since sometimes expenses wont be shared evenly across the group) that is a link to the Attendees table. Wha...

treverr by 4 - Data Explorer
  • 328 Views
  • 1 replies
  • 0 kudos

Trying to create an "averageif" in airtable

Hello team! I am trying to calculate the average weekly attendance in airtable. I downloaded the data from airtable and was able to calculate it in excel using an "averageif" function but I am not sure how I can implement it in airtable. The last col...

cs_0-1684959715206.png
cs by 4 - Data Explorer
  • 672 Views
  • 5 replies
  • 2 kudos

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...