Formulas

I have a field with the number of days, and the total fee. I wanted to create a formula field where I could add this logic below. Is this possible to compute? One month or less (≤ 30 days)10% of the Fee2-3 Months (31-90 days)20% of the Fee4-6 Months (91-180 days)50% of the Fee7-8 Months (181-240 days)60% of Tof the Fee9-10 Months (241-300 days)75% of of the Fee

If I have one date in a single cell, then I would use the formula DATETIME_FORMAT({}, 'MMMM) to convert that date into a month.  However, sometimes when using a Look Up I'm pulling multiple dates, separated by commas, into one cell. I'd like to find a formula that will convert all of these multiple dates into the month equivalent. So solving the 'error below'.  Any help much appreciated. Thanks. 

I'm using formula: SET_TIMEZONE(NOW(),'America/Los_Angeles') I want it to show the current time in LA but it keeps returning the UTC time instead. Any idea what's wrong with the formula?

Hi everyone,I am having trouble with a SEARCH() formula that isn't acting as I would expect. I have this long text in the field "FORMULE" :"1: Pratiquer une activité2: Me consacrer3: Vivre des expériences4: Pratiquer un sport"I want to search for the position of this string : "Vivre des expériences"Here is my formula : LEFT(FORMULE,FIND("Vivre des expériences",FORMULE)) And here is my result : "1: Pratiquer une activité2: Me consacrer3: Vi"-> The end string finishes by "Vi" which is one caracter to long, it should finish by "V" only... It is an example but it changes when you look for the other words, other example, when I search for "Pratiquer un sport" it gives me this result :"1: Pratiquer une activité2: Me consacrer3: Vivre des expériences4: Pra"-> It is now 2 caracters too long, it shloud finish by "P" onlyDo you have any solution about this ? I am surely missing something...Thanks a lot for your help

I know using a formula like this-IF({T-Shirt Size} = "extra small",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -2), 'MM/DD/YYYY'),IF({T-Shirt Size} = "small",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -6), 'MM/DD/YYYY'),IF({T-Shirt Size} = "medium",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -13), 'MM/DD/YYYY'),IF({T-Shirt Size} = "large",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -22), 'MM/DD/YYYY'),IF({T-Shirt Size} = "extra large",DATETIME_FORMAT(WORKDAY({Expected Final Files}, -30), 'MM/DD/YYYY'),""))))) Gives me the date in the format I want but I would like to have it in bold and Airtable says "Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date." I know this is a result of using DATETIME_FORMAT. I updated the formula to:IF({T-Shirt Size} = "extra small",DATEADD({Expected Final Files}, -2, 'days'),IF({T-Shirt Size} = "small",DATEADD({Expected Final Files}, -6, 'days'),IF({T-Sh

Hi, I've looked up my situation to see what the problem is and I'm still getting an error message.  I want to multiply two fields to get a total.  Qty field and Cost field.  Here is my formula.  I get #ERROR Thank you for the help.  

Hi! Does anyone know how to restrict access to a shared interface? I gave a read-only user access to an "editable" interface I made for my creators so that she couldn't utilize it. For her to submit information, I made a read-only version with a form; however, I cannot unshare the editable interface at this time. I can't find a "remote access" option for her account. How come? If it helps, my account is Pro.

Hello, I would like to ask someone from the community for advice, or the correct formula, since within Airtable I solve such tables, or a linked table with several fields / windows, while it is a kind of recorder and at the same time an evaluation of records in the recorder of activities of members of a team.So I have one table called Schedule of activities where I have the first column which belongs to the Activity ID, the second column which belongs to the date and the third which belongs to the Type of Activity and then there are other columns with checkboxes, each one belonging to a specific member - e.g. Member A, Member B, Member C etc. (one column for one member).And then I want in the next table, or table field /table window called Summary of members' participation in Type of Activities, I wan to make a summary of the number of participation of specific members in specific types of activities. So I have in it the first column belonging to the ID of Summary, then there is a colu

Hello all, I am stumped. I am trying to combine data from two multiple select fields, into one. For the sake of confidentiality, I have created an example of what I am working with, using part of the Greek alphabet instead of the actual data: The goal is to combine these two columns into a third that looks and behaves exactly the same as the first two, simply with the data from both combined, into one. As easy as this feels like it should be, every single option I’ve seen either turns the output into text strings (which renders it useless for our tracking purposes), or else it requires a great deal of manually typing or copy-pasting the individual options of the multiple select, into the formula, one by one. It should be noted that while I have only used four Greek letters here, the actual number of entries we are working with is well over 600, and with far longer names, so such a process would be a grueling time-consumer. Surely there must be some way to automate this? Also note t

Hi I have a formulaDATEADD({Kick off},{Time Estimate (Fibonacci Minutes)},"minutes") Whereby {Kick off} is an date field set to ISO and 24 hour time{Time Estimate (Fibonacci Minutes)} is a drop down with a Fibonacci sequenceI want the DATEADD formula above to return the expected job completion date and time so that I can feed it straight into my calendar. Weirdly, it's an hour out.For eg a kick off date of  2023-05-10 00:01 with a fibonacci of 21 returns 2023-05-09 23:22, when it should be 2023-05-10 00:22.Any ideas? 

Hi all,I'm using Airtable to plan and track renovation and landscaping tasks. I have a table that has one field (text) for tasks and a 'prerequisites' field that is linked to the tasks field. This shows me other tasks that need to be done first. I am trying to create a formula that will show me whether the task at hand is a prerequisite task for any others.I tried  IF(FIND(Task, Prerequisite), "Yes", "No")  but that (kind of obviously) always return "No" because a task is never a prerequisite of itself.How can I get it to identify if the a task is a prerequisite for any other task?Alternatively, is it possible yet to automatically produce a field for the link in the opposite direction when records are linked within the same table?Thanks!

I am using a date and time field that shows in ET- i.e 9/22/2023 11:00am. It was showing up in a weird way in automations, so i followed a formula that i saw in a pervious post to format it -DATETIME_FORMAT({Launch Date & Time},'M/D/YYYY \\at h:mma') - but then for some reason it's showing is as "9/22/2023 at 4:00pm". I obviously want it to show as "9/22/2023 at 11:00am"- What am i doing wrong?

Hi everyone,I'm trying to create a formula field that pulls either one of two dates (depending on which one is the earliest) or gives "Pending Date" if both columns are empty. I've tried several different formulas and have gotten close, but I can't get the formula to fill in "pending date" still -- it always gives me #ERROR. Here are two formulas I have tried: IF(IS_BEFORE({Date 1}, {Date 2}), DATETIME_FORMAT({Date 1}, 'YYYY'),IF({Date 1}=BLANK(), DATETIME_FORMAT({Date 2}, "YYYY", "Pending Date")))and  IF({Date 1}, DATETIME_FORMAT({Date 1}, 'YYYY'),IF(NOT({Date 1}), DATETIME_FORMAT({Date 2}, 'YYYY'),IF(NOT(AND({Date 1}, {Date 2}, "Pending Date"))))) Can someone tell me where I'm going wrong? 

Hello Everyone!Can someone help me troubleshoot why using IF formula with arguments containing field values with decimal points return errors? All the fields are in currency format with precision of 1.00 except one with duration type field in seconds and in decimal format. Here's my formula and there's at least 4 different results to expect (FULLY-PAID, PARTIALLY-PAID, OVER-PAID, NO PAYMENT and N/A if all 4 logical arguments are false. Below is my formula.  IF({Total Amount Paid (ToDate)}=0,"NO PAYMENT",IF({Total Amount Paid (ToDate)}<{Total Amount Due (ToDate)},"PARTIALLY-PAID",IF({Total Amount Paid (ToDate)}={Total Amount Due (ToDate)},"FULLY PAID",IF({Total Amount Paid (ToDate)}>{Total Amount Due (ToDate)},"OVER-PAID","N/A"))))  There are only two fields used in the formula and i noticed that whenever the value of the {Total Amount Due (To

Hoping for some help! I have a column with a date in, and two other columns, one with a start date and one with an end date, I want to do a conditional / IF rollup that brings me through a value if the date in question falls between the start date and end date in my other columns grateful for any help!

I’m brand new to Airtable and getting to grips with it all so forgive me if this is a simple and stupid question. I’ve got a table logging expenses by two people. I’m using a currency field to add the amounts spent by each person. Now I want a second table that shows the overall funds both people start out with and then a field that shows the current funds available which updates according to the expenses logged in the expenses table. Can someone explain to me how to do that? I don’t even know what sort of keywords to look for in the help sections. Thank you so much for any help! Anna

Hello,I need to sum the two smallest values between three values.Example:- Value 1: 10- Value 2: 20- Value 3: 30The two smallest values are "Value 1" and "Value 2".How to do this via a formula (or other

Hello all,I currently am trying to create a formula in which I calculate days since last contact, with some of the source cells either being blank or having "N/A" as a value. I plan to make cells either all blank or "N/A" if the person hasnt been contacted. what I am trying to do is have a tonow(date of last contact) formula in which if the cell is blank or N/A it states "N/A" instead of "invalid date".Thanks!

Hi there!I'm wondering if there's a way I can add a distinction for fields that have the same data. For example, there's two entries that are on the same date (09-22-2023). I have been trying to find out a way to somehow, say, put 09-22-2023a and then 09-22-2023b so I know which one is entered first and so on.I'd appreciate any insights. Thanks in advance!

Hi everyone! 🙂In one table, i got Name + Surname + Email AddressIn another table, i only got Email Address, but i need to fill in the Name + Surname that i have in the other table.How could i do this?Thanks a lotMarco

I cannot decide if I'm better off with an automation or else I'm just not meant to do if else formulas. I need to first check if a date field is not blank. If it is not blank, then I want to compare it with another date field. If it's later than other date field I want to show 'launch date moved out'. I know this formula is not comparing but it's what I ended up with (and it's not working)IF({Original Launch Date} & "-"THEN {Launch Date}>{Original Launch Date},'Launch Delayed') 

Using the "created_at" field, I need a new date field (due_date) that takes created_at and adds x number of days. It's easy to do this with a formula field, and I have that set up already.However, I also need the flexibility of being able to manually overwrite the due_date if necessary. Forumla fields can not be edited. How can I benefit from the efficiency of auto-calculating a due date + the flexibility of manually adjusting if necessary?Thanks!

Hi, I'm trying to make a formula that combines different records to a readable title.I'd like to add the Product field to the formula, but only if it has not more than one value and only if the value is not 'Algemeen'. The last part I can fix, but I need some help with the check for the amount of values. The current formula combines 5 fields, with only a check for the Product field. Any help for the extra check is appreciated. {Team} & "-" & {ID} & " | " & IF({Product} != 'Algemeen', {Product} & " | ", "") & {Section} & " | " & {Name}  

Hello below is a table of scores and the corresponding status. I also have a risk register for each risk I want to be able to select the probability (1-5) and the Imapct (1-5) and it automatically returns the status as defined by the table below. Is it possible? Many thanks if you can help! Andrew  

Hi,I am trying to create a simple IF Statement to produce the result PASS or FAIL if the value in another column is >= 80%:  In Column 1 ('% germination rate on second check') are % figures with values ranging from 0% to 100%. The purpose of the Column 2 ('PASS/FAIL'), is to produce the word 'PASS' if the value of Column 1 is >= 80%, or 'FAIL' if otherwise. Currently all cells in Column 2 are showing 'FAIL', irrespective of the % figure showing in Column 1. Is this some kind of syntax or formatting error on my end? Here is my formula: IF({% germination rate on second check} >= 80, "PASS", "FAIL")Thanks for the help! 🙂