Formulas

I want to clean up a base for old, deprecated fields. The problem is, I want to make sure they’re not being referenced in a formula field somewhere. (Or that their Look-Up or Roll-Up copy on another table isn’t in a formula.) Is there an easy way to check dependencies? Or an easy way to search all formulas at once?

Hello ! I am is looking for a simple solution for joining the values of two “Multiselect field” into third “Multiselect field” and keeping the list updated if values in initial fields change. And can you please advise how to manage the list of values of “Multiselect field”, - for example create conditional lists etc. Thanks in advance ! Alex.

I have a table with a status column. I created a Kanban view for these status and I would like to set the current date when a certain status is set. For example when status is STARTED set the started_date column to NOW() So I use the following formula : IF(status = 'STARTED', NOW()) It works to set the date but the issue is when I switch the item to the ENDED status the started_date is cleared. I would like to know if there is a way to set the column value when the condition is true and do nothing when it’s not. Thnaks

Hi there, I am using a formula field to pull the time stamp (and t-zone) from a Date and Time field. I am using this formula currently: DATETIME_FORMAT(SET_TIMEZONE({Day 1 - Start}, ‘America/Los_Angeles’), ‘h:mm a’). This works wonderfully, however, if the time and date field is blank (which, in my case, does happen) my time stamp field shows #ERROR. How can I add to this formula so it knows to leave the field blank if the date and time field is blank? Would appreciate all and any help on this. Daniel

Hey there, I’m looking to capture: Total Number of Vendors (1st column) that are in each Lifecycle Stage (Ex: 2 in PO Launched, 1 in PO Placed) and The % of vendors relative to the total (Ex: 40% of all vendors have a Lifecycle Stage of PO Launched) Questions: Does Lifecycle stage need to be a linked record? For my case it doesn’t (although that’s how it’s shown in the screenshot) Can that live in this table, or will it need to live in a separate, linked table? Thank you!

Hi, I need to calculate the evolution between two records. Row 1 = Week 1 ; 50 followers Row 2 = Week 2 ; 75 followers etc… In a column: (75-50)/50= 50% (progression of follower) How to do it in Airtable? Thanks

Hey everyone! I’m creating a column in a table where I’m concatenating a date field (formula driven), client name and default text. The result of the concatenate is adding an extra day to the formula driven date. Below is the formula and I uploaded an image of the dates reflecting the additional day. Any insight on what’s causing this? It’s so weird! Formula in the concatenate field: CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date},‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”)

Hey all! I’m stumped. I have a “Link to” column compiling every testing date, then a “Most Recent Test Date” rollup column using MAX (VALUES) to list back what the most recent date is. However, sometimes we schedule testing dates in advance. HOW do I get a column to determine what the most recent testing date is before TODAY? Thanks so much!!!

{Business User Value} + {Time Criticality} +{Risk Reduction - Opportunity Enablement} / {Story Point Estimate} The first part works great then I add the / and error its nothing to do with the format of the fields as {Story Point Estimate} + {Business User Value} works fine… any ideas? its seem really odd to me

Hi there, I’m using airtable to compare an actual quantity with a goal quantity, then using an If, Then statement to tell me whether I’m at my goal, need to increase, or need to decrease my actual. Here’s my current formula: IF({% of total}={Goal % of total}, "OK", IF({% of total}>{Goal % of total}, "Trim", "Expand")) This is working fine, but what I would really like is if I were able to specify a range for values that are “close enough” to the goal. For example if {% of total} is plus or minus 0.5 of the goal, I want it to return OK. Anyone have any thoughts on how to do this? Thanks in advance!

I’m trying to get a formula to run only when the cell has a value. I work with hotels, so we send out weekly summaries of the entertainment scheduled for that week. I am creating a column that will automatically pull out the specific location (Venue) within that hotel where the performance is taking place. This is the formula I am currently using (which works): CONCATENATE("| ", {Venue (from Venue)}) Not all hotels have a specific venue name for the performance location. If the “Venue (from Venue)” field is blank, I would like to make it so this formula doesn’t even run. I did some reading in the forums and tried the below formula (amongst others), but it isn’t working. IF({Venue (from Venue)} = BLANK(), BLANK(), CONCATENATE("| ", {Venue (from Venue)}) Can someone help me? Thanks!

Is there any way to have checkboxes disappear after they are clicked? I know there is a way to sort so that all the completed records (with a checkbox) filter to the bottom but is there a way to move them so they don’t appear amongst other uncompleted projects? Thank you!

I’m trying to create a 30/45/60 second countdown timer, how would I create a formula for TIMESTR(NOW()) and +30 seconds into the future. I would then point this new field to the countdown app. sorry im very new to this

I need some help. I have a column of address like below: 12345 Anywhere St, San Fransico, CA, 90000 I need to add the street 12345 Anywhere to is own column called street. Same with city ect. whoever can solve has a VENm0 coming with 25 dolls.

Hi, I can’t get the formula to work. Can we do condition formula on Single select option? Example; Single select option Category A B I’ve tried, IF(Category=A / IF(Category=‘A’ & IF(Category=“A” but none work. Please help. What I need is; IF Category is A, “Yes”, Else “No” I have no problem for digits, but stuck for text. Thank you.

I am having trouble with the second IF part of this formula, it doesn’t return any results. I also tried it on it’s own and it still doesn’t return a result. IF({Writer Owned (adds up to 100%)}=.33330, VALUE(“16.66”), IF({Writer Owned (adds up to 100%)}=.33340, VALUE(“16.68”)))

hi! I have a strange issue. My formula (nested conditionals based on fields you can see in the image) provides different results for the same values! It turned out that the reason lies in the ID Roadmap link field. The first record has only one linked record while the second one has two - one of which is has empty values. When I delete that link, the Result formula changes to “ID excl from denominator”. However, I’m not able to delete those links one by one (it’s a long story). The question is: how do I create a formula that will be based only on values I can see?

Hi team, Building a similar clone as to the Producthunt upvote feature. I would like to know how I can use the counter in airtable fields. As in when the user clicks on the Frontend the counter should get updated on the frontend as well as the record/database. Also a limitation in doing this the following way Is it possible to add a vote/like button to a public air table (without the need to have collaborators) Base design Do you mean something like this: [image] The button links to a form with the option prefilled. [image] Submitting the form redirects to the original page where you can see the updated vote counts. Here is the live demo. is one can vote only through submitting the form. Thats, not the whole idea if I just wish to upvote the content I needn’t fill the whole submission form for it. Any suggestion would be helpful here Almas

I have a projects table where I link multiple records from a resources table. The linked records (resources) have different attributes (e.g. aaa, bbb, ccc, ddd) that come from a “single-select” field. My challenge now is to find projects where resources of a special attribute (e.g. bbb) are linked. Is there a function/formula field I could use to color records in my view? I’m not the full Expert on automation or formulas, but I think of a formula that goes to the link of the record, looks for the attribute, and then makes it possible to color or maybe write a “true/false” to another field and I color/filter/group for that. Currently the only solution I could find is to separate the resource-link field into a "link “bbb” resources here (links based on a filtered view) and all other resources on another field. Thus I see in a coulum quickly if a resource with the attribute “bbb” is linked. I don’t like this approach as I want to have all resources linked to a project in one field. It wou

4 columns to do this Shipping Method - single select: boat, shipping Payment Received - checkbox Date of payment - date modified linked to payment received Estimated Delivery Date - formula. I want to write an if statement. This is what I have so far but I’m not sure how to write the second if statement IF(Shipping=“boat”,DATEADD({Date Quoted},52,‘days’),DATEADD({Date Quoted},21,‘days’)) I would like to know how to write is so that is when payment is received estimate delivery is from payment date if date modified is blank then from today boat +52days if flight +21days if date modified is not blank then from date modified boat +52days if flight +21days

Hello. I have the same question as here - Display multi-select items not selected But it seems as though there is no answer in that thread. Does anybody know the solution to this? What formula can show only unselected in some field items?

Hi, I’m trying to copy Airtable cells into the whiteboarding tool called Mural. I have a formula that removes line breaks in the text field it’s calling and I want to take those cells and copy them into Mural to generate sticky notes for each individual cell. Now, if I copy a few cells at a time, it works fine, but this is tedious. So if I copy all the cells, then Mural seems to combine some of the cells for some reason into one sticky note. If I created a formula that aggregates all the cells into one in a different table (separated by a line break in the cell), when pasting it into Mural it adds quotation marks around the entire thing so Mural treats it as one giant sticky note. Any ideas on how to mass copy and paste from Airtable cells into Mural?

Hi the community. I have some difficulties with a formla. I deliver package and i want to calcul the date of the preparation in relation to the delivery date decided by the customer I want to calcul a date but this is conditionate with the result of a column. Column A, i have a date : 12/04/2021 Column B, i have two type on result : “GLS” or “Chronopost” This is what i want is : If GLS = Date of the column A - 2 day. With my example the result : 10/04/2021 If Chronopost = Date of the column A - 1 day. With my example the result : 11/04/2021 Sorry for my english. Could you help me please ? Thank’s a lot, Matthieu from www.lagreentouch.fr

Hello, In airtable how can i add the formula to send me a notification that is linked to the overdue of the Due date field? To send me an email notification that i need to follow up

Hello! I’m looking to create a calculated field that shows me the number of days it takes to complete a record. The start date should be when the record is created, and the end date will be based on a dropdown field’s value (e.g. when the status field is set to “complete”). My thinking is that I need to create three formula fields: The date when a record is created (I’ve managed to achieve this part). The date when the status dropdown field is set to “complete”. The difference between the two dates in days (I’ve managed to achieve this part). So basically I’m missing how to create the 2nd field. Am I approaching this the wrong way? Is there a better way to show this report that doesn’t involve using an app add-on? Thank you!