Resolved! Question on conditional formulas
What am I doing wrong with this one? Please help! If ({Date Due} IS_BEFORE{Date to work on it}), “ :nauseated_face: ”))
What am I doing wrong with this one? Please help! If ({Date Due} IS_BEFORE{Date to work on it}), “ :nauseated_face: ”))
Hello, dear Airtable community. I want to generate a unique payment ID, based on the sum, date, cashier, and the type of transaction. Everything has been good by far, until I decided that I want to try using emojis. So, I assumed it should be a mix o...
Hi, I’d like to auto-assign due dates to our writers. However, there are some conditions: I don’t want due dates to ever occur on weekendsSome writers work 3 days a week (M,W,F) and some 5 days a week. Is there a formula I can use to do this and all ...
Is it possible to recreate this formula in Airtable? Where: i = IRR L = Loan amount F = Points and all other lender fees P = Monthly payment n = Month when the balance is paid in full Bn = Balance in month n This equation can be solved for i only th...
I’m a professional writer, and I have a table where I put all the projects I turn in. On the table, I list how long a project took me (duration) and and how many words it was (#) (along with other factors). What’s the easiest way to create a formula ...
I’ve tinkered with a few ways of doing this, but wanted to get some ideas about the most efficient way. I have this full address string: Street address: 1600 Pennsylvania Ave NW # 15 City: Washington State: DC ZIP Code: 20500-0003 I want to extract t...
Is there a way to utilize a concatenate formula + Link to Another Record to have a lookup work automatically? I currently have to copy/paste the concatenate result from the formula into the Link to Another Record to get the result via lookup.
Can formulas be used in the free trial version ? Tried to use the multiplication * function but not successful. (error) message coming up.
I have used spreadsheets for a while now but certainly not an expert. I would appreciate any help with formula for a ledger. I enter my info by date. Some entries have debits and credits.I would like the table to calculate new balance for each entry.
Hi everyone! I have done several searches and cannot find exactly what I am trying to do. I am relatively new to all of this and my ADHD brain struggles with all of the technical stuff at first, so I apologize if this is very obvious. I want to simpl...
Hi There! I have a series of tasks with deadlines. The field next to “Deadline” is a countdown titled "Days Left’ with the amount of days left until the task is due. However, I don’t yet have/need deadlines for some of the tasks, so the Deadline fiel...
Hi there, I am trying to figure out a formula to extract max year for a specific company based on the fields below. Max year should pick a max year for that particular company in the field. I tried using MAX function but it didn’t appear to work, is ...
This is the data in my cell <ANUZ2B2KI2XTG;ANUZ2B2KI2XTG;23.93+0=23.93;Me;26.12;Ig:r#5:><A20AY8YZ1X41HY;A20AY8YZ1X41HY;23.96+0=23.96;Me;26.12;Ig:r#5:><A2FATTUNY7ADJL;A2FATTUNY7ADJL;23.99+0=23.99;Me;26.12;Ig:r#5:> I am trying to extract the first numb...
Form some reason if I try to multiply or divide I get error however addition and subtraction works fine. What am i doing wrong?
Hi all, couldn’t find this question in existing community chats so thought I’d ask y’all. I am trying to allocate different numeric values for different selections as follows. Strength of Connection: “Very Strong” = 3 Strength of Connection: “Strong...
Hi there, I’m trying to create a “ToDo” base with sub-tasks. I have one table with different “project” in every row, and second table with a few tasks linked to each project. Now, I want to create a rollup record to pull out the percent of the task t...
Hi all. Does Airtable track the date when someone enters data or changes data? We are using it to schedule our content calendar, and I’m trying to create a dashboard showing how long it takes to move a project through several stages, which appear as ...
Hi everyone! I’m surprising myself by not being able to figure this out. I swear at one point or another I had been able to pre-fill an airtable form with a field that includes an emoji. For example, I want to pre-fill a single-select {Status} field ...
Hi all, I am formatting my database to show how long a volunteer has been with us (in order to determine when to give them their 1 year of service, 2 years of service etc), however, the cut-off date each year for our volunteers is 30th April. For exa...
I have a table of Customers and a table of memos which are related to the Customer by Account number and in the memos table I put a note each time I speak to the customer with basic info of the date the person I spoke to and what was said. In the Cu...