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

Forum Posts

Calculating Differences Between Records in Increments of 1, 5 and 10

Hi All - I'm struggling with creating calculations on the base shown below. What I'm trying to do is calculate the % change in total enrollment growth by 1YR, 5YR and 10YR between Fall Years for each university (it would be a changing calculation wit...

HTDuck_0-1692985358148.png
HTDuck by 5 - Automation Enthusiast
  • 1161 Views
  • 7 replies
  • 3 kudos

Customized Form Issue

Hi there, We use airtable to track employee hours and payroll. A former employee set up our base so I'm a bit unfamiliar how to make changes to the boards within airtable. However, I have two new employees that I'm trying to generate a random employe...

Resolved! Rollup fields not calculating

Hello,I can't find the issue here that is preventing what i thought would be a very simple table calculation.I have a table called Deals with many different fields but one of them is a currency field that i want to use a rollup field in another table...

Alec by 6 - Interface Innovator
Solved
  • 1831 Views
  • 10 replies
  • 4 kudos

Resolved! Multiselect Calculation

Im not sure how to ask this in order to look up suggestions. I have an order form that I created on a workstation. Based on the photographer, the client is given the options offered by that photographer. Once they select the options/services they wou...

shalablake by 5 - Automation Enthusiast
Solved
  • 924 Views
  • 3 replies
  • 2 kudos

Total Teaching Hours

I am creating a hour tracker for my instructors (around 70 of them).  I have a requirement in which I show how many hours they taught each month.  In table 1 (Instructor Hours) I have everyone listed, with a formula field for total hours to date and ...

groy8285 by 4 - Data Explorer
  • 240 Views
  • 0 replies
  • 0 kudos

Resume Parsing

Hi All,Is there any option if I upload a resume in My Airtable base and with the help of any extension,  parse the basic information like Name/Email ID/Contact No./Current Company in respective field.I agree that I am expecting too much from Airtable...

Help/Any Solutions?

Hello All,I need to migrate all of my records from an old base in to a new base.  The records in the old base have been assigned a number (through Auto ID plus a formula).  We are leaving the old base behind, importing all of the records in to the ne...

Rita_Spanu by 5 - Automation Enthusiast
  • 481 Views
  • 0 replies
  • 0 kudos

Resolved! Compare text in a field with a table, using lookup and logic

Hello Community, please help to solve in an elegant way!I have record, and in a field called "FOOD" I have text separated by comma, let's say in the text I have"FOOD" = Apple, Carrot, sausageI then have another table caleld "FOOD CATEGORIES" with all...

Find and substitute the single € symbols

Hi !I'd like to substitute the "€" symbol only when it's alone in a field. (alone but with a space in front)For example, I've sometine a field with :1.00 €2.00 €€€€and it's very ugly in our contract.  ><I thought at the "LEN" and "FIND" formulas but ...

Nocode34130 by 5 - Automation Enthusiast
  • 385 Views
  • 0 replies
  • 0 kudos

Resolved! Using a formula to populate EDITABLE date fields?

I run a table that keeps track of content my team creates for a digital billboard. When we hear about new content, our project manager builds out a production schedule based on the date the content is supposed to go live on screen.To help my PM with ...

Steve-O by 5 - Automation Enthusiast
Solved
  • 1100 Views
  • 7 replies
  • 3 kudos