I have this IF Statement Formula: IF( {UNH Facilities}= "UNH Facilities - GH Cleared", "", IF({UNH Facilities}= "UNH Facilities - Supplying Items", "") ) but I want to add one more piece that returns both an orange and purple circle ...
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...
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...
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...
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...
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 ...
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...
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...
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...
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 ...
