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

Forum Posts

Trying to organize sales data

Hi everyone!I'm trying to organize my sales data in my Airtable base.I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.Now I want to run automatic calculations on the data. To give an example: i...

UrbnJ by 5 - Automation Enthusiast
  • 47 Views
  • 1 replies
  • 0 kudos

Shiftplan with formula and counter

Hi there, im new to airtable and need some help. I would like to create a form in which people can register for a work shift. There are four shifts with a maximum number of participants. For example:Shift A = Max. 5 participantsShift B = Max. 2 parti...

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
  • 344 Views
  • 8 replies
  • 1 kudos

Individual fields/topics to repeat

Hi, we track which topics will be posted to social media mainly in calendar view in Airtable. Ex. Have "receipe" show up every Wednesday on the calendar instead of having to input the date manually. Any suggestion on how to accomplish that? 

Jhelm by 4 - Data Explorer
  • 263 Views
  • 1 replies
  • 0 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
  • 195 Views
  • 2 replies
  • 2 kudos

Resolved! Lookup value from a table based on 2 single select field

Hello,I need help with figuring out how to lookup the right price of an item for a particular customer from a table.I have an order line item table that contains "Customer Name" and "Item Name". Using this information together I want to look up the p...

aryan201215_1-1714237335267.png aryan201215_0-1714237122543.png
aryan201215 by 4 - Data Explorer
Solved
  • 286 Views
  • 3 replies
  • 2 kudos

Resolved! Issues with formula - Attempting an on hold client button

Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote","On Hold - Do not Quote"))We are hop...

ahenry by 4 - Data Explorer
Solved
  • 357 Views
  • 3 replies
  • 0 kudos

Resolved! IF statements with numbers and time

Hi everybody,if I can ask for help with formulas in IF statementsI have developed Glide app with Airtable, works really good.I have a table WorkOrders, and among other columns, I have:"Start time", "Start kilometers", "End Time", "End kilometers", "T...

VedranN by 4 - Data Explorer
Solved
  • 235 Views
  • 3 replies
  • 2 kudos

using sum values in grouped fields for other formulas

How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful ...

Screenshot 2024-04-12 alle 13.06.15.png